Recordset Object

[Wes Peters]

I'm trying to programatically determine if a form's underlying recordset is
empty or not. I've tried checking Me.Recordset.RecordCount and
Me.Recordset.EOF with no success. What would be the best approach? I'm
using Access 2000 / SQL2000

Thanks,
Wes

 

[Baz]

I'm trying to programatically determine if a form's underlying recordset is
empty or not. I've tried checking Me.Recordset.RecordCount and
Me.Recordset.EOF with no success. What would be the best approach? I'm
using Access 2000 / SQL2000

Thanks,
Wes

I wonder what you mean by "no success"?

Anyway, it's far better to use the form's recordsetclone e.g. test for:

Me.RecordsetClone.Recordcount = 0

There seems to be something terminally buggy about the form Recordset
property. As soon as you start referring to it, Access gets very uppity and
a crash is inevitable.

 

[Wes Peters]

I've experienced those terminally buggy crashes and will stay away from the
Recordset property. The RecordsetClone seems to do the trick.

Thanks.