HELP!
I have a query that gets a few values from a form. The problem I'm having
is a date field in the query. When I put the value in the criteria, it
works fine. When I put the same value as an item in a combo box of the form
and try to pass the value, I get "This expression is typed incorrectly or
too complicated to be evaluated".
Here it is:
'6/30/' & Str(Year(Now()))
The options in the row source of the combo box are as follows:
"January";"'6/30/' & str(year(now)))";"July";"12/31/' & str(year(now)))"
Is my formatting incorrect? I get the same thing when trying to pass "0 or
1" to denote both yes and no values of a checkbox. It doesn't like the word
OR. Any thoughts would be GREATLY appreciated as always. Thanks!