Query Help

[ChrisDo11]

I have a query based on a table which consists of Contractor Names. Each name has a corresponding description(deficiency). A contractors name will show up 2-3 times in the table as different records depending on the number of deficiencies they have.

I want to build a query that will let me pick the contractor name from a pull down, then query all the different records(deficiencies) with that contractors name.

can anyone help with this?

 

[llkhoutx]

Build a form with customerID, customerName fields in a combo box and such other field from the two tables as you desire and a query recordsource for the form to display dscrepancies. The query has CustomerID in the customer and discrepancy tables linked with the customerID from the combobox as the criteria. Requery the form on the AfterUpdate event of the combo box.