Invalid Use of Null

[Aftab Ahmad]

Hello!

I am getting error as Run-Time Error '94' Invalid Use of Null on my code

DoCmd.OpenReport strReportName, ReportView, , strReportFilter, acWindowNormal

What should I do?

[Nauticalgent]

Without knowing anything about your report, it seems your filter variable, “strReportFilte r” is Null. Do you know how to check it?

Usually you could simply wrap you variable in the Nz() Function to avoid the errror: Nz(strReportVar iable,””). But in you case, this would only open a blank report.

I would recommend some code that checked for the Null value and then alerted the user that there was no data to report. Some thing like:

IF IsNull(strReportFilter) Then
     MsgBoxd “No Data To Report”
Else
     DoCmd.Open.....
End If

[twinnyfo]

I also believe this error is related to your previous thread. Your filter could have a series of variables and parameters, and if only one null value is used incorrectly, you will get an invalid use of Null error. This could also be related to your underlying record source for the report. If there is an invalid use of Null there, you will also get the error. Does the report open properly without the filter?

We cannot solve this problem until 1) we see how you are creating your filter string and 2) we see the underlying query/record source for the report.