Search filtered by different columns in listbox

[vector39]

Hi everyone

So I have a working search bar that filters data from a listbox based on what the user types in. The list box has 5 columns, 2 are text, 2 are date/time and 1 is yes/no data types. The search bar filters based the first column (company name) and the criteria is as follows in the query:

Like "*" & [forms]![frmMain]![SrchTxt] & "*"



I'm just wondering how do I filter columns based on different data types (each column)? I know I need to add more but for the second free text column, I copied the same criteria in the first but nothing came up in the search bar. if anyone knows how to do this any sort of guidance is MUCH appreciated!

Also, do I need to create more queries? Or can I use the same query just have a different criteria under each field?

[pbaldy]

I'd use dynamic SQL, but in a query you can use this for the numeric and date fields:

http://access.mvps.org/access/queries/qry0001.htm