access 2003 no query results for a form

's Computer Specifications

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?

's Computer Specifications

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 (E-Mail Removed)> wrote in message
news:3E5C4A52-1823-4768-A5F4-(E-Mail Removed)...
>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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to get query results in a form field (Beginner with Access)	bkowalski24@gmail.com	Microsoft Access Forms	2	20th May 2009 05:18 PM
How do I use checkboxes in an Access form to get query results?	Rookie7777	Microsoft Access Getting Started	1	22nd Feb 2008 10:04 AM
access command in form to export query results to excel	rsbutterfly219 via AccessMonster.com	Microsoft Access Form Coding	2	5th Jun 2006 09:23 PM
Access 2003: Printing each of grouped results of Query in a New Pa	=?Utf-8?B?U0hD?=	Microsoft Access Reports	3	24th Oct 2005 11:05 PM
Form results to Access 2003 database	=?Utf-8?B?dG9laGVhZHM=?=	Microsoft Frontpage	5	12th Jul 2005 06:54 PM