Multiple criteria in Form

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

Guest

I'm trying to develop a form with the option to find records containing
various criteria from a Main Members form that you would choose as needed.
The filter criteria that I want to be able to pick and choose to search on
are: LastName, City, Province, MemberID, and Benefits (a yes/no field).

I want the results to display but would also like to be able to print a
report based on records found.

I am having a terrible time with the expressions needed and am in way over
my head. Can anyone help?
 

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

Create Filter from on multiple criteria 1
Access Dcount (multiple criteria) 3
Filter form criteria on multiple fields 6
Should I re-create criteria using form filter of just use the relevant query as recordsource? 2
Set criteria for multiple queries entered in one dialog form? 1
Multiple Filter Criteria 4
Query Form 1
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top