If it is the same one then this code should be in the place where the report is being run from.
I think I know what is meant by this, but I'll put it another way and add something.
Whatever event you're using to open the report, test for the field value. If not as desired, don't open the report. Something like
Code:
IF IsNull(Me.ManufDate) Then
Exit Sub
Else
Docmd.OpenReport....
End If
Not sure if you're saying the report has no data if the field in question is Null or "". If that's the case, you can also use the report OnNoData event.
EDIT: OK I think we all assumed this wasn't done via a Macro.
Last edited by Micron; 01-18-2017 at 05:28 PM.
Reason: additional info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.