pass null to a query

  • Thread starter Thread starter Gonzosez
  • Start date Start date
G

Gonzosez

I have a combo box.
if the value is null.
How do I pass it to the query to look where the field is null.
Thanks
 
The SQL would look something like:

WHERE (MyField = Forms!MyForm!MyCombo OR (MyField IS NULL AND
Forms!MyForm!MyCombo IS NULL))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query not pulling parameter value from combo box 1
NOT function not working - can prove with screenshots 1
Parameter Query With Null Values 3
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Pass Through Query to Sybase SP 18
Options Group and Query Criteria, revisited 3
Finding null 4
Combo box null value 5

Back
Top