Filter query results based on Month in combo box error

[BDibz]

This specific statement in my query keeps giving me trouble:




But I don't see why, since the expression should just return a month name, which should match one of the options available in the combobox. Any ideas why this may be breaking?

The error I'm getting when I use the Where statement is

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)

[ranman256]

Make a month table,1-12
1, Jan
2, Feb
etc...


the combo will display Jan-Dec, but bound on the #.
then the query looks for : month(orderDate)

[BDibz]

Bingo

Make a month table,1-12
1, Jan
2, Feb
etc...


the combo will display Jan-Dec, but bound on the #.
then the query looks for : month(orderDate)