From: Iram on
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
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
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