Replacing rst with rst

mattalexx · #1 (**permalink**) 05-13-02, 15:31

In Access 2k VBA:

I cloned the recordset of a form when it opens:

Code:

Set rst = Me.Recordset.Clone

When the form closes, I want to ask the user whether he wants to save the changes. If he doesn't, I want to replace "Me.Recordset" with "rst":

Code:

In case it pertains to the problem: the form won't allow adding or deleting of records

Is this possible?

rnealejr · #2 (**permalink**) 05-13-02, 17:19

Have you tried using the updatebatch method instead ? Use this with locktype of adlockbatchoptimistic.