Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    60

    Unanswered: Replacing rst with rst

    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?
    Matt Alexander
    mattalexx@softhome.net

    Don't click here.

    Odigo: 5408962
    AIM: mattalexx
    ICQ: 138006220

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you tried using the updatebatch method instead ? Use this with locktype of adlockbatchoptimistic.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •