Filter dropdown list based on previous field selected?

[Cam]

Hello,

I am development tables for a new database and ran into a problem. In my
output table, I have several fields with the main one order#, part# and
operation. All these fields are drop down list for user to select from the
lists. The lookup tab is a combo box and source is from a reference query
which have lists of order#, item and operation. One order# will have
multiple operations.

How do I design so that when an order# is selected from the lists from the
user, the next field is operation field that only show the operations based
on the selected order#? Thanks

 

[John W. Vinson]

Hello,

I am development tables for a new database and ran into a problem. In my
output table, I have several fields with the main one order#, part# and
operation. All these fields are drop down list for user to select from the
lists. The lookup tab is a combo box and source is from a reference query
which have lists of order#, item and operation. One order# will have
multiple operations.

How do I design so that when an order# is selected from the lists from the
user, the next field is operation field that only show the operations based
on the selected order#? Thanks

If you're using Lookup Fields in the table datasheet, AFAIK you can't. See
http://www.mvps.org/access/lookupfields.htm for a critique of what many of us
consider a misfeature.

It's easy if (as recommended!) you use a Form instead of lookup fields in a
table.

You can base the Operations combo box on a Query referencing the Order combo
box on the form. Use a criterion like

=[Forms]![NameOfForm]![NameOfCombobox]

on the order field, and Requery the combo box in the afterupdate event of the
order combo box.