So I have a checkbox in a form, when selected, the query should only selects records that have a certain checkbox field ticked. when the form checkbox is left blank, i want it to show all records. My code is as follows:
IIf([Forms]![Subcode Analysis]![SelectChk]=Yes,Yes,"")
Its giving me this error: "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"
I'm assuming the problem is with the "" part of my code. Is there a command that would tells it to include both checked and unchecked boxes?
Thanks,
Patrick