No Current Record

[Bill Reed via AccessMonster.com]

I'm trying to test for No Current Record in a DAO recordset. It happens
when my strSQL returns a blank recordset from the db. I was trying to use
IsNull(rs(0)) or IsNull(rs.Fields(0)) but they don't work. Any suggestions?

 

[Alex Dybenko]

try to check for EOF property:

if not rs.EOF then
....

 

[Jim C.]

Hi,

One other alternative is to check that rst.RecordCount > 0.

Jim