Quick search for customer jobs? Combo Box? 1

[aph]

Have a table with a list of inspections listed via numbers and customer names (plus other inspection data) so the list of inspections is 1 - whatever but different customers are entered at different times.
EG.
Inspection / Customer
1 / A
2 / B
3 / C
4 / B
5 / B
6 / A

But I want to create a form and/or report so when customer B is selected inspections only for that customer will be shown E.G 2 , 4 and 5 in the case above.
I tried doing this with a List/combo box to select the customer name required but when the form list the data if you go to the next record it shows you the next record on the main table and not the customer I want the data for only.
any ideas on the best way to do this?

 

[dhookom]

This is typically accomplished with a main form for selecting the Customer and a subform that displays the related inspections. You set the Link Master/Child properties of the subform control to accomplish the filtering.

Duane
Hook'D on Access
MS Access MVP

 

[aph]

Cheers dhookom for the info, maybe if I create a new form customers from a table then inspection from another table then setup as you say I may be in luck