linking to a table based on combo box selection

[Katy]

I want users to be able to select a choice in one combo box and have that
determine which selections are available to them in a second combo box of
subcategories (the list is too huge to put in one, and the form would be too
huge to have a combo box for each subcategory). Is that possible? is there a
better way to do this?

I haven't used Access to build a database in a few years, so I'm a little
rusty...

THANKS!

 

[Jeff Boyce]

Katy

You've posted in a "tables" newsgroup, so I'll assume you're trying to do
this in a table.

Don't! Instead, use combo box controls in a form. In the AfterUpdate event
of the first combo box, requery the second combo box. Base the second combo
box on a query that includes the first combo box's value as a criterion.

Take a look at "Cascading Combo Boxes" as a topic at mvps.org/access or via
Google, or in Access HELP.

Regards

Jeff Boyce
Microsoft Office/Access MVP