Thread
:
access 2003 no query results for a form
View Single Post
#
2
April 17th, 2010, 05:10 PM posted to microsoft.public.access.forms
Ken Snell
external usenet poster
Posts: 177
access 2003 no query results for a form
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
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"Portfolio Man" Portfolio
wrote in message
...
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?
Ken Snell
View Public Profile
View message headers
Find all posts by Ken Snell
Find all threads started by Ken Snell