access 2003 no query results for a form

  • Thread starter Thread starter Portfolio Man
  • Start date Start date
P

Portfolio Man

I am new to access and self and manual taught. I have created a query in
support of a form with two criteria that is working well. I would like to
have a message appear if there is no information. Currently the form
displays just the background. Is there an easy way perhaps using an Event
Procedure?
 
In the form's Load event procedure, you can use this code to pop up a
message box:

Private Sub Form_Load()
If Me.Recordset.RecordCount = 0 Then _
MsgBox("No Records!")
End Sub
 
Back
Top