Searching multiple fields that aren't a given for input

[WithoutPause]

I think I've tried just about very combo for the Like code and nothing works.

strWhere = "Like "" * """

[June7]

Sorry, LIKE and wildcard might not work nice with date/time criteria. I don't use dynamic parameterized queries so not sure.

I use only the VBA conditional approach.

If you want to provide db for analysis, follow instructions at bottom of my post. Identify objects involved in issue.

[WithoutPause]

I still have the issue where my passing of data works, but it doesn't show until I play with the Filter Toggle or rerun the previous process.

[June7]

Have to analyze code if you want to provide. See post 32.

Refer to link at bottom of my post for debugging guidelines.

[WithoutPause]

I went back and read the Allen Browne stuff and realized that code was using the same form. I am passing the info to a second form. I ended up passing the where statement via OpenArgs and then doing a filter on the second form. Now I just need to handle no search criteria being based and returning all records.

[June7]

Why use OpenArgs? Why not the WHERE CONDITION argument?

[Dal Jeanis]

If no OpenArgs are passed, then just set the filter off.