Sub menus

D

Doug11046

I am trying to set up an Access database that will allow me to first look up
a catagory and from that category to next look up particluar items related to
that category.

The application involves 2000 or so items that that can be grouped into 20
or so categories. To try to pick 1 of 2000 items directly using combo boxes
is too time consuming and so the idea is that the user first picks a category
which then limits the combo box to only those items in that category.

Thanks for any help you can provide.
 
J

John W. Vinson

I am trying to set up an Access database that will allow me to first look up
a catagory and from that category to next look up particluar items related to
that category.

The application involves 2000 or so items that that can be grouped into 20
or so categories. To try to pick 1 of 2000 items directly using combo boxes
is too time consuming and so the idea is that the user first picks a category
which then limits the combo box to only those items in that category.

Thanks for any help you can provide.
Click to expand...

Use a Form with two combo boxes. The first combo box would list the categories
(let's call it cboCategory). The second combo would be based on a query of the
items table referencing cboCategory as a criterion:

=[Forms]![YourFormName]![cboCategory]

You'll need to Requery the item combo box in the AfterUpdate event of
cboCategory.

John W. Vinson [MVP]
 
Top