Are If statements possilbe in Queries?

[Iram]

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

 

[John W. Vinson]

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?

IF isn't the right tack here... you can use OR though. Base the Category combo
box on a query referencing the Team combo. You don't describe your table
structure but it would be something like

SELECT <whatever> FROM <tablename>
WHERE (Forms!MasterFormName!Team = "ACCOUNTING" AND Category IN("Accounting",
"Other")
OR
(Forms!MasterFormName!Team = "ESTABLISHMENT" AND Category IN("Establishment",
"Enforcement", "Legal", "Other")
OR
(Forms!MasterFormName!Team = "ENFORCEMENT" AND Category IN("Establishment",
"Enforcement", "Legal", "Other")
ORDER BY <something useful>;

 

[KARL DEWEY]

Search on 'Cascading Combos' to find what you need.

 

[Dorian]

see reply in other post
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".