Query Filter using a form

[dgaller]

I am trying to do a simple query that is filtered off a form where the user can select a sign i.e(>,<,<>) in an unbound [combo1] and a date field [Date]. I thought I could then put in the query criteria [Form]![Search Form]![Combo1]&[Form]![Search Form]![Date] but when I do I can a error shown below.
This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)
Can anyone help with what I am missing?

 

[Alansidman]

Take a look at this video. It should help you get where you want to be.
http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

 

[dgaller]

This is very informative thanks. But I need to go to the next step. How can I use what is in the video with a selection of i.e (<,>, Between ect)

 

[HiTechCoach]

The best way I have found to handle this is build the SQL statement's WHERE clause with VBA.

A method I like to use is to update the QueryDef with VBA code.