if query returns none, do not open form

[glrs430]

Hi,

I'm new to access and am in need of some help.

I have a search window that will open a form and display searched results. However, I would like it NOT to open the form when there are no results from the query. Instead, I would like to have a pop-up informing user that there is no result based on their search criteria.

Thanks,
Gina

 

[nullZero]

This goes in your form that displays your search results...

Private Sub Form_Load()
    If Me.Recordset.EOF Then
        MsgBox ("No Records Returned")
        DoCmd.Close
    End If
End Sub

 

[glrs430]

Thanks for getting back to me.

Do I need to declare Me.Recordset? I included the code as is and Access 97 is giving me a compile error, indicating that it doesn't recognize Me.Recordset.

Thanks,
Gina

 

[Norie]

Gina

You might want to take a look at DCount.

You could use this to tell you if there are any records based on your criteria and then open/not open the form accordingly.

How are you currently opening the form and what exactly is your 'search window'?