Hi John,
Thanks for your effort. The error msg no longer appears and it works with the "X" selected. However, if the Null is selected, no records are returned even though that field contains Null values.
John
Hi,
I'm relatively new to Access and have this problem. I have a table (Agent) with a Text field called Active which contains either a Null value or an "X". I use a text box (txtCit) on a form (frmAgentReport) to supply the search criteria for a report which has the the Query as its...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.