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
 
Top