"No Data" msg box

R

RealEstate

When requesting data in a report, I simply use the "NoData" in properties to
have an appropriate message popup. Is there any way for a similar message box
to appear in a form, if no data is displayed?
 
F

fredg

When requesting data in a report, I simply use the "NoData" in properties to
have an appropriate message popup. Is there any way for a similar message box
to appear in a form, if no data is displayed?
Click to expand...

Try this in the Form's Load event:

If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "No Data"
End If
 
Top