multiple criteria search page

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I am using the following code to search for records in my database:

DoCmd.OpenForm "Form1", ac Normal, , "[Field1] Like '*" &Me.Text1 & "*"

This works for a single field, is there a way to write the search so that I
can incorporate multiple fields? Can I use "AND" so that the user can enter
several fields of information for the purpose of searching?

Thank you for any assistance.

LB
 
Lauren,

See my reply to Ripper T's post of earlier today in the sameNG, titled
"Filtering with multiple combos problem". It should give you an idea on
construction the filter string.

HTH,
Nikos
 

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

multiple criteria search page (revised) 1
Access Dcount (multiple criteria) 3
coding for search page 2
search criteria filter 1
search for multiple records in a form 4
Filter Multiple Fields 1
Calling Access 'form' from other applications 0
Data filter--No Records Found 1

Back
Top