Close Form Attached to Query If No Records Found

[Swantekmar]

I have a query that shows its results in a Form View. The form works great as long as the query returns records that match the query criteria. The problem is that when there are no records that match the criteria the form is opened but none of the fields or command buttons are visible, so basically I am left with a blank screen. When I switch to the EDIT VIEW I can see that I am actually still in the actual form.

Is there a way to tell a query to close itself and/or the associated form if there are no matches for the criteria submitted?

 

[Rich]

FormLoad event If RecordsetClone.RecordCount=0 Then
DoCmd.Close
End If

 

[RV]

Look here:
http://www.access-programmers.co.uk/ubb/Forum4/HTML/001796.html

It's a good idea to search the forum for similar questions.

Suc6,

RV