Message on No Data event

[Guest]

I have a form that has a stored procedure as its recordsource and would like
to have a message or something come up when opening the form if there is no
data returned. Right now if the end user opens the form and there are no
records in the recordsource than a blank screen comes up. This confuses the
user. I know in Access there is an "On no data" event for reports that
allows you to code a message to pop up. Any suggestions on how to get a
message pop up stating no records where returned in Access Project? BTW,
iam using SQL server 2000 with Access Project 2000 front end. Thanks for
any help.

 

[Larry Linson]

Access 2003 has a NoData event for Forms, too.

Examine the Form's Recordset... if it has no Records, close the Form and
display a message, or reset the form to Allow data entry... the only time
Access displays the blank Form is when there are no records AND adding new
records is not allowed.

Larry Linson
Microsoft Access MVP

 

[KB]

You mentioned that Access 2003 has a NoData event for Forms, too, where do i
find it? still lost