Hello,
I am in the process of creating a Form that will allow users to enter criteria into text boxes/combo boxes and query data. I want the users to have the option of leaving the boxes blank so that all data is returned for null values. Right now I am using this expression to query data [Forms]![Form1]![cmbStore] and [Forms]![Form1]![cmbStore] is null. This seems to be working fine for all but the date range query. I was using the "Between" function for the date range, but cannot figure out how to apply "Is Null" to the query.
I posted a similar question earlier and a few AcccessForums.net members suggested I use the filter option for this type of form. I am not totally opposed to the filter method, however, I am not very good with VB and there appears to be a lot of code in that solution.
I attached an example of what I am trying to accomplish. Thank you for your help!