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
 
Back
Top