Multiple search criteria based on table

[Alex]

Hi all.
Here is my question:

I have created 2 simple tables with their relevant forms. Table names are
Customers and Friends, so are the names of the forms.

I am trying to create a query for each table, which will allow me to type
some criteria (based on 10 fields of the table) in order to find the contacts
that match with them and print them out in a report.

I would like to be prompted to type 1) Please enter first name 2) Address 3)
Postal code etc...up to 10 fields

I would appreciate any help...!

 

[Allen Browne]

Alex, take a look at this article:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The downloadable example shows you how to combine any number of fields to
make a search form that matches just the boxes where you actually entered
some values to find.

 

[Alex]

Tnx for the post Allen. Currently reading the article...