how to check if your recordset in empty

M

mike

I'm doing a findfirst on a recordset, but if the recordset comes back empty,
how can I check for it?
 
K

Ken Snell

If both the BOF and EOF properties of a recordset are True, you have an
empty recordset.
 
S

Steve Schapel

Mike,

If rst.RecordCount > 0 Then
rst.FindFirst <criteria>
etc

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Shared Link is showing empty notebook 1
empty recordset 6
Printer Page & Drawing Page 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Recordsets-Old and New 5
recordset vs collection 2
Using Findfirst recordset to search memo field type 11

Top