Searching more than one field at one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that contains a subform. The main form contains the Primary
(parent) business information, and the subform contains the Secondary (child)
information. I would like to be able to search both the main form and
subform for information without having to search each form one at a time.
For example,

The secondary account calls for information, and I need to find who it
belongs to, I want to simply search one form, and not have to do a search on
the subform, and then the main form.

Does anyone have any suggestions?
 
See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to set the RecordSource of the main form so it
contains only those records that have a match in the subform.

An alternative approach would be to use a subquery in the Filter string of
the main report. If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

The subject line suggests you want to offer the user several filter boxes,
and respond to whichever ones they fill in. For an example of how to do
that, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Hopefully once you get 2 or 3 of those ideas working, you will be able to
use them in combination to make the powerful search form you desire.
 
Could this code be built in Access, or would it be necessary to use a program
such as VBA?
 
Back
Top