"No Data" msg box

[Guest]

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?

 

[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?

Try this in the Form's Load event:

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