how to check if your recordset in empty

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I'm doing a findfirst on a recordset, but if the recordset comes back empty,
how can I check for it?
 
If both the BOF and EOF properties of a recordset are True, you have an
empty recordset.
 
Mike,

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

- Steve Schapel, Microsoft Access MVP
 
You must log in or register to reply here.

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

empty recordset 6
FindFirst method not found 2
Not empty recordset? 2
Recordsets-Old and New 5
Error: Argument Not Optional 0
is Nothing vs = Empty 5
Using Findfirst recordset to search memo field type 11
Checking for an empty recordset 1

Back
Top