(Q) I'm using a control on a form as a parameter for my query. I've defined the
criteria in the query as
[Forms]![myForm]![myControl]
How do I set this up so that if the field is left blank, all records are returned by
the query?
(A) Change the criteria in the query to
[Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null
|