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
 
Back
Top