Run only if records exist

[SueBK]

I have a form that opens filtered against various criteria.

I have code sitting in the "on load" to update information on the form. If there's no data against the filtered criteria I get a de-bug message. This will obviously (unnecessarily) freak out the client

I assume there would be a relatively simple line of code I can add at the beginning to say "if no records don't run the rest of this code"?

 

[SOS]

Perhaps (untested):

If me.Recordset.RecordCount<> 0 Then
...do your stuff here
End If

 

[SueBK]

Lovely. I knew it would be easy. Its just knowing what VB calls things.