multiple criteria search page

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
 
N

Nikos Yannacopoulos

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
 
Top