Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple field search form with blank fields

Status
Not open for further replies.

Simon22

Technical User
Feb 1, 2001
54
CA
Hi all,
I've been reading old posts for an hour now and I haven't quite found the answer to my question so here it goes...

I have a membership list. ID#, First Name, Last Name, Address, etc...

I would like to create a form with about 10 optional search criteria fields. For example. If I wanted to find all members from Halifax who are also members but don't care about their age.

My question is, how would I go about making a form with 10 fields, some of which may be left blank and then return a report showing the FULL records which match the criteria?

Thank you very much :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top