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

    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
    nono
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    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
    Posts
    74
    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
    nono
    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
  •