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?
On Mon, 3 May 2010 12:41:58 -0700, 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? 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; -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Are If statements possilbe in Queries?
Search on 'Cascading Combos' to find what you need.
-- Build a little, test a little. "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 |
#4
|
|||
|
|||
Are If statements possilbe in Queries?
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". "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 |
Thread Tools | |
Display Modes | |
|
|