If I use a query that depends on the value of the dropdown, what if no value is selected in the drop down, what value gets pased? i assummed Null ans wrote my where clause like this:
IIf([Forms]![ReportingMenu]![SupervisorReport]=Null,"Is Not Null",[Forms]![ReportingMenu]![SupervisorReport])
Am I wrong to assume the value is NULL?
IIf([Forms]![ReportingMenu]![SupervisorReport]=Null,"Is Not Null",[Forms]![ReportingMenu]![SupervisorReport])
Am I wrong to assume the value is NULL?