Table Question

A

Antavas

I'm creating a table that has 2 dropdown fields. The first drop down field
has 5 options (A,B,C,D,E). The next dropdown will contain the subtypes for
the 5 options. How do I set it up so that when someone selects an Option (for
instance A) only the subtypes for Option A are displayed in the subtype
dropdown?

Thanks,
 
J

Jeff Boyce

You don't! Access tables store data, Access forms display data. Use the
forms!

You can use "cascading comboboxes" (search on this term) in your forms to
accomplish what you describe.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top