I have a combo box on one of my forms which returns a number, I am using this number in as criteria for a field in a query, however if no option in the combo box has been selected I want to use a default set of criteria, but access keeps telling me I have invalid syntax. Could someone tell me how I could do this?
IIf(IsNull([Forms]![frm_a]![cmbo_b]),<2 or >3,[Forms]![frm_a]![cmbo_b])
The problem occurs when I use <2 or >3 in the middle of the if statement.
No comments:
Post a Comment