Text Box search of Form with a Combo as Part of Form search

[jbulldog]

I have started creating a database with a bound form. What I

want to know is how to use either one of the records for a

search for the related records associated with it or a separate



text box to initiate the search. at the same time I want to replace

say two of the fields text boxes with a combo box that will

retrieve any and all records for the associated fields related to

the search field, which will be two columns of data drop data.

[June7]

Consider using a form/subform arrangement to display related records.

Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially:

Build a Custom Filter in Your Form in the Access Forms: Tips and Techniques section

And the 3 about comboboxes in Access Forms: Control Basics section