If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Are If statements possilbe in Queries?
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 |
#2
|
|||
|
|||
Are If statements possilbe in Queries?
Addressed elsewhere.
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|