"No Data" msg box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top