Thank-you Allen - Your code works perfectly!
Mike

"Allen Browne" wrote in message
...
Cancel the form's Open event, e.g.:

Private Sub Form_Open(Cancel As Integer)
If Me.Recordset.RecordCount = 0 Then
Cancel = True
MsgBox "Nuffin 2 c here."
End if
End Sub

(Note that checking whether there are records may cause the form's events
to trigger in an order different to that published by MS.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Mike from Moriches" wrote in message
...
Greetings -
Is there a Forms event similar to the On_No_Data event with reports?
I have a small form that builds a filter for a recordset. If I run a
DoCmd.OpenReport I can trigger No Data event when the filter finds no
records. However, if I use a DoCmd.OpenForm with the same filter, a
blank form displays. I would like to prevent the Form from displaying if
no records are found by the filter. What is a good approach to capture
the fact that no records meet the filter criteria? Thanks in advance for
any suggestions,
Mike N.