Get query Criteria from a combo box

[Eljefegeneo]

That I now understand. Thank you.

 

[Eljefegeneo]

Thank you too arnelgp, it works fine now. I didn't know that the eval function could do away with the double quotation marks and thus be able to pass the parameter fromthe combo box or text box to a query.

 

[arnelgp]

yes it is literal string, but Month, and Now are public function so you can call the whole expression in Eval function:

debug.print Eval("Month(Now())") and it will return 2
debug.print Eval("Month(Now())+1") and it will return 3