PDA

View Full Version : Replacing rst with rst


mattalexx
05-13-02, 16:31
In Access 2k VBA:

I cloned the recordset of a form when it opens:
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":
?

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

Is this possible?

rnealejr
05-13-02, 18:19
Have you tried using the updatebatch method instead ? Use this with locktype of adlockbatchoptimistic.