3 combo boxes on form

[shanewa]

I would like to create 3 related combo boxes. For instance I have a person, tag #, and serial # from a query of 2 tables.

If I choose the person in the combo box the other combo boxes would change to the person's unique tag # and unique serial #.

Conversely if I choose the unique tag # it should show the unique serial # and the one person who is in possesion of this object. and so on for picking the serial # from a drop down combo box. Any help is appreciated.

 

[THoey]

Each of the listboxes will have a base query selecting all of the possible selections for that field. In the OnUpdate event for each listbox, you will need to requery the other two, with the added WHERE clause for the listbox that was changed.

Does this make sense? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[shanewa]

I think I am going to need more detail. I created 3 new seperate queries. So a total of 3 combo boxes based on 3 queries with just the data needed to populate the combo box. I then create a blank form and create the combo boxes with the wizard to lookup the data but I cannot find OnUpdate. and I am not sure how to add the WHERE clause? I hope I am going in the right direction. thanks for your help!