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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Opening form unexpectedly closes other form 0
Issues Displaying results in Combo Box in Access 2003 2
Query in a sub form 1
Load Query Results Into Form 9
No Data Selected for Form 4
Create a form for users to query data. (Access 2003) 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top