Record Selection

K

KP

Hi, I hope you are having a great day.
I have report based on query that checks a yes/no field
for yes matching records, i.e., were any parts on order.
When I open report and there are matches, I get said
records. When no records match, I get a blank report. Is
there a way to have a MsgBox display (No Matching Records
Found) instead of a blank report? If so, how I make it do
that?

I tried the following (which works on a form ON LOAD
event) on report OPEN, but get an error on IF statement:

If Me.RecordsetClone.EOF Then
MsgBox "No Records With Parts On Order"
DoCmd.Close
End If

Thanks in advance and have a great day.
 
A

Allen Browne

Reports have a NoData event which fires if there are no matching records. To
prevent the report opening, cancel that event.
 
Top