Access2000 VBA Recordset Name

Topic

New Reply

I have created a single table Access2000 database and an Access form with which to enter the table

Reply | Quote

Replies

What it requires is a reference to the object variable you’ve assigned the recordset to. In other words, if you do this:

Dim rst As Recordset
Set rst = Me.Recordset

Then rst is the object you use to MoveFirst, or whatever.

Reply | Quote

Wait, I just reread your post. If you don’t want to actually move the record pointer, you need to use the recordsetclone, although an ADO recordsetclone is a somewhat different animal from a DAO recordsetclone, so you need to specify which object model you’re using.

Reply | Quote

Your advise to use the recordsetclone proberty seems like the best solution. I am relearning VBA (last used V1) and it seems simplest to confine myself to the newer ADO model. While the help system documents both DAO and ADO Clone methods, I can find no mention of ADO recordsetclone property support. Can you point me in the right direction?

Reply | Quote

Recordsetclones aren’t the same thing at all in ADO. In fact, what they are is separate recordsets created using the clone method. So if you want to use ADO, use the recordcount property of the subform’s recordset, which will return a -1 if there are any records.

Reply | Quote