Page 2 - Access 2007 search box within form

How could you modify this code to search with multiple textboxes instead of just one? I have multiple fields and would like only one Filter button.

Concatenate as many parameters as you want. Example with text, date, number data types.

Me.Filter = "fieldname1 = '" & Me.textboxname2 & "' AND fieldname2 = #" & Me.texboxname2 & "# AND fieldname3 = " & Me.textboxname3

Will all textboxes be required in the search expression? I mean will user be required to enter a value into all the search boxes? If any are allowed to be blank, different code needed to deal with that.

Thanks for the reply. Ideally, I would like to have one textbox to search multiple fields, like a traditional search box. Currently this is the code I have:

Me.Filter = "Email Like '*" & Me.Text138 & "*'"

As is, it works fine. However, I would like it to also search First and Last names, as well as companies (this is a contact database). Can I do this in the way you described?

Thank you so much!

I have tried putting this code in:

Me.Filter = "Email Like '*" & Me.Text138 & "*'" And "First Like '*" & Me.Text138 & "*'"

But it does not appear to be working. Any thoughts?

In form view, at the bottom with the record selector is a search/find dialog box.

bnag, sorry I lost track of this thread. If you are still wanting solution, try:

Me.Filter = "Email Like '*" & Me.Text138 & "*' And First Like '*" & Me.Text138 & "*'"