I cant get AbsolutePosition to work!!

[techgnome]

Let's see.... how can I put this? Simply put, you are doing it wrong. That's why it doesn't work.

.OpenRecordset does just that, it opens a recordset. You need to assign it to a Recordset variable _FIRST_ before you try to access the properties like that.

set myRecordset = db.OpenRecordset("Info")
lbl.caption = "Record " & myRecordset.AbsolutePosition & " of " & _
myRecordset.RecordCount

Once you have opened the recordset, then and only then will the RecordCount and AbsolutePosition work.

Tg