<div>
you can check recordset count on form's open event, and cancel it:<br />
<br />
<br />
if Me.Recordset.RecordCount = 0 then<br />
Cancel = true<br />
end if<br />
<br />
DoCmd.OpenForm in that case will produce runtime error which you have to handle<br />
<br />
<br />
<a href="http://www.pcreview.co.uk/forums/no-data-form-open-t3987721.html" rel="ugc">http://www.pcreview.co.uk/forums/no-data-form-open-t3987721.html</a>
</div>


you can check recordset count on form's open event, and cancel it:


if Me.Recordset.RecordCount = 0 then
Cancel = true
end if

DoCmd.OpenForm in that case will produce runtime error which you have to handle


http://www.pcreview.co.uk/forums/no-data-form-open-t3987721.html [http://www.pcreview.co.uk/forums/no-data-form-open-t3987721.html]

<div>
&lt;&lt;on form's open event&gt;&gt;<br />
<br />
&nbsp; Really don't want to use OnOpen for this; that's a little too early and might be hit or miss. &nbsp;Your not guaranteed that the forms recordset has been loaded until you hit OnLoad.<br />
<br />
JimD.<br />

</div>


<<on form's open event>>

  Really don't want to use OnOpen for this; that's a little too early and might be hit or miss.  Your not guaranteed that the forms recordset has been loaded until you hit OnLoad.

JimD.


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I see that a form does not have a &quot;On No Data&quot; event like a report has. &nbsp;<br />
How can I craft an On No Data for a &nbsp;form?<br />
<br />
thank you.<br />
<br />
this is what I use for a report:<br />
Private Sub Report_NoData(Cancel As Integer)<br />
<br />
&nbsp; &nbsp; MsgBox &quot;No Data&quot;<br />
&nbsp; &nbsp; Cancel = True<br />
End Sub<br />

</div>
</div>


Experts,

I see that a form does not have a "On No Data" event like a report has.  
How can I craft an On No Data for a  form?

thank you.

this is what I use for a report:
Private Sub Report_NoData(Cancel As Integer)

    MsgBox "No Data"
    Cancel = True
End Sub


No Data and a Form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.