Open form if query has results

[Pusher]

Hi all,
How do i make a form open on a event (on Load of another form) if a query has results?(the form that opens displays the results) If there is a need for it then it opens, if there is no results then it does nothing.
Thanks

 

[John Big Booty]

I would open the form that is feeding off the query and put the following code in it's On Load event;

    If Me.Recordset.RecordCount = 0 Then
        MsgBox "No Records For That Criteria"
        DoCmd.Close
    End If

If there are no records to display the user only sees the message box.