Results 1 to 3 of 3
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149

    data change, re-edit the record

    When I open a form, and edit a record.
    I receive the following message box & need to click a OK button before entering some text :
    The data has been changed.


    Another user edited this record and saved the changes before you attempted to save your changes.
    Re-edit the record.

    how to ignore this message box show up?
    thanks.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Who else is using the record?
    What else is going on in code?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Sounds like you have a write conflict
    See Write Conflict Errors (isladogs.co.uk)

    In your case the other user changing the data is yourself!
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 08-04-2019, 02:52 AM
  2. The data has been changed. Re-edit the record
    By adrianf44 in forum Forms
    Replies: 5
    Last Post: 02-12-2019, 06:30 PM
  3. Replies: 2
    Last Post: 05-04-2017, 01:10 AM
  4. Replies: 16
    Last Post: 02-13-2017, 09:29 PM
  5. Replies: 0
    Last Post: 03-13-2012, 12:57 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums