hello again...
Im running access 2.0 (yuck... I know)
I have the following in one of report footers...
If [MonthClosingStock] <= [MinStockLevel] Then
[Warning].Visible = True
Else
[Warning].Visible = False
End If
How would I run this code only if the report has records? Because at the moment if the user selects a future month by mistake, the report doesnt open as it just diaplys the code window and says that monthClosingStock has no value....
Thanks for your help!
Im running access 2.0 (yuck... I know)
I have the following in one of report footers...
If [MonthClosingStock] <= [MinStockLevel] Then
[Warning].Visible = True
Else
[Warning].Visible = False
End If
How would I run this code only if the report has records? Because at the moment if the user selects a future month by mistake, the report doesnt open as it just diaplys the code window and says that monthClosingStock has no value....
Thanks for your help!