Search Table by Selection in Combo Box

[jsaliers]

I have a database that stores part numbers in relation to a parent part type. What I am trying to create is a form that allows a user to view all parts by selecting the parent part from a combo box. How do I go about getting all of the different parts to show up on the form in the correct text boxes when a selection has been made from the combo box?

Thank you in advance!!

Jon Saliers

 

[telephoto]

You have 2 tables, one of parent parts and one of related child parts.

A form exists with a combobox linked to parent part numbers

Construct a query with both tables. Display all fields. Use the value of the combo box in the form as the criteria in the parent part number field. (can be set up in expression builder). Save query.

Make a continuous form based on the query.

Back to the combo box form, in the combobox properties, event, after update, set the code to open the continuous form. (Or make a command button labeled "Find" to open it if you don't want to do any code at all).

HTH

Telephoto