BuildCriteria and Filter Property Question

[striker]

Has anyone got an example of how to apply multiple query to a filter by form. I want to be able to do it in code.

I get the feeling that i need to use the buildcriteria method but am a bit confused by Access help when it says that you have to run the build criteria for each field that requires a filter and to then concatenate the strings. Maybe its just the concatenation that confuses me after all.

An example of its use would be excellent.

Thanks for your time.

Steve

 

[llkhoutx]

Build yourself a query in the QBE frame with multiple criteria; then view the query in the SQL view (to display the criteria).

Needless to say, the criteria in syntax sensitive and takes a little practice. View your own query examples and build accordingly.