Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unanswered: update records error

    I've got a form on which I use a combo box to assign the value to the textfields... I want to allow user to edit the records in the database using this form.

    it works fine... but for some reason, I get this message:

    "The Data has been changed

    Another user has edited this record and saved the changes before you attempted to save your changes

    Re-Edit the Record"

    pls advice
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2001
    You are updating the current record through code and record locking is throwing the message.

    Remove the recordsource of the form and do not reset it in code. You could also use a snapshot recordset on the form since you are updating using code functions.

    Not sure what your live form needs are.
    More info if this does not help.

  3. #3
    Join Date
    Nov 2003
    the purpose of it, is actually meant for users to update the branch information through this form.

    thanks for the help to solve the problem. the error is due to the record source set in the form.

    thanks again --> Bravo
    Last edited by damnnono_86; 01-28-04 at 01:26.

Posting Permissions

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