VBA code for search button in a form

[alicevuap]

Hello!



I created a split form based on a query, in order to perform a search from a table. I added an unbound text field where to introduce the keyword, and a button with on click event in Macro builder as follows:

The issue is that i would like to perform the search in more fields and the limited number of characters in the "where condition" does not allow me to add more than 3 fields.

Could someone help with an VBA code equivalent to this one, in which i can write all the conditions? (as far as i know there are no character limits in VBA)

Thank you!

[pbaldy]

It would look like a wherecondition:

http://www.baldyweb.com/wherecondition.htm

but the repeating fields mean your table is not normalized:

http://r937.com/relational.html

[alicevuap]

My form looks like this:

How can i write the code to generate the results in the bottom table and not in a new form?

[pbaldy]

Personally I'd change the recordsource, but the closest to what you're doing:

Me.Filter = "Subject..."
Me.FilterOn = True

The filter string would look like the link.

[alicevuap]

Thank you! It worked!

[pbaldy]

Happy to help!