Simultaneous search of two fields which are in separate tables.

[BruceWaller]

I am working on a form that I need to be able to search based on two fields located in separate tables. The tables are joined in a one to many relationship. Do I have to start with a query?

 

[SydneyGeek]

Do you want to drill down to a specific record? If you do, a common way to do that is to use combo (drop-down) boxes in the header of the form.
Search this forum for cascading combo or cascading listbox -- there are plenty of examples.

Denis