Close Form on no Data

[hullstorage]

I have a form that show me results from a query

What i want is to if there is no data on the form then cancel this event
and show message box saying sorry no records or something like this

I have a field on one form where i enter the postcode then a button
which opens the form with the matching record from the query

so on no data or blank form then ask user to try again

thanks in advance

simon

 

[pbaldy]

I suspect the most common method is to test before opening the form:

If DCount("*", "QueryName") > 0 Then