Is it possible to have If statements in a query?
in [Forms]
|
From: Iram on 3 May 2010 15:44 Hello, I have a subform and in this suform I have a combobox field called "Category". In this combobox I have a select query that pulls the Category and TeamName. On the master form I have a floating combobox called Team. When I choose a team in this field I would like the subform combobox to be narrowed down a little as such if possible... If the Team field on the master form is Accounting I would like the Category combobox to be limitted to "Accounting" and "Other" team names. If the Team field on the master form is ESTABLISHMENT I need the Category combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other". If the Team field on the master form is ENFORCEMENT I need the Category combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other". If this is not possible how else can I do this? Thanks. Iram/mcp
From: Jeanette Cunningham on 3 May 2010 17:32 This is what we call 'cascading combos'. There is a sample database here: http://www.rogersaccesslibrary.com/forum/topic389.html and one for subforms here: http://www.rogersaccesslibrary.com/forum/topic388.html Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Iram" <Iram(a)discussions.microsoft.com> wrote in message news:0795C45B-BD62-424F-A294-64B942094B76(a)microsoft.com... > Hello, > I have a subform and in this suform I have a combobox field called > "Category". In this combobox I have a select query that pulls the Category > and TeamName. On the master form I have a floating combobox called Team. > When > I choose a team in this field I would like the subform combobox to be > narrowed down a little as such if possible... > > If the Team field on the master form is Accounting I would like the > Category > combobox to be limitted to "Accounting" and "Other" team names. > > If the Team field on the master form is ESTABLISHMENT I need the Category > combobox to be limitted to "Establishment", "Enforcement", "Legal", > "Other". > > If the Team field on the master form is ENFORCEMENT I need the Category > combobox to be limitted to "Establishment", "Enforcement", "Legal", > "Other". > > > If this is not possible how else can I do this? > > > Thanks. > Iram/mcp
From: Dorian on 3 May 2010 18:00 see other post -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Iram" wrote: > Hello, > I have a subform and in this suform I have a combobox field called > "Category". In this combobox I have a select query that pulls the Category > and TeamName. On the master form I have a floating combobox called Team. When > I choose a team in this field I would like the subform combobox to be > narrowed down a little as such if possible... > > If the Team field on the master form is Accounting I would like the Category > combobox to be limitted to "Accounting" and "Other" team names. > > If the Team field on the master form is ESTABLISHMENT I need the Category > combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other". > > If the Team field on the master form is ENFORCEMENT I need the Category > combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other". > > > If this is not possible how else can I do this? > > > Thanks. > Iram/mcp
|
Pages: 1 Prev: Are If statements possilbe in Queries? Next: Filter Combo Box Listing |