Create Filter from on multiple criteria

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

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter form criteria on multiple fields 6
Multiple criteria in Form 1
Multiple Filter Criteria 4
search criteria filter 1
Multiple report criteria on command button 8
VBA: How can I use a string variable as autofilter criteria? 4
dropdown to filter records 1
Filter form based on query result 2

Back
Top