|
(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!myContrl OR forms!myForm!myControl Is Null
|
