Create Filter from on multiple criteria

[Guest]

I am tryng to create a form to find records in a membership database based on
the selection of criteria. The filter Form is based on a MainMemberForm and I
want to be able to filter to find records based on any or all of LastName,
MemberID, City, Local, StartDate and/or Benefits(a yes/no field). I want the
results displayed on the form and also want to be able to print the results.

I know that this can be done but I am in way over my head with the codes and
am now completely lost...is this enough information for anyone to help?

Many thanks

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The article includes a sample database that illustrates how to build such a
form. The "extending" part explains how to print a report matching the
results.