Results 1 to 3 of 3
  1. #1
    joecamel9166 is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    85

    Restore changed data in subform


    I have a subform that holds the shipping data. On my parent form, I need to place a message box that pops up if any of the data in the subform has changed.
    I use this subform on multiple forms so the code cant be placed into the subform.

    The code I currently have is on the btnSave_Click but it only works if the first 3 digits of the zipcode changed.

    Also if that messagebox = vbno then I need the data on that form to revert back to what it originally was.

    thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    if you are watching the subform to change, then you DO want the code in the sub form.
    Even if its in different master forms, the same fields cant change w/o notice, no matter the master form.

  3. #3
    joecamel9166 is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    85
    Not the answer I was looking for, But I guess I can make another subform and just enter the code in that one.

    For some reason the docmd.runcommand accmdundo is throwing me an error.
    also tried accmdredo with same error.

    is there a command to revert changes?
    or while thinking about it, maybe put the code in before update instead of after update?

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

Similar Threads

  1. Highlighting data changed
    By pharrison74 in forum Reports
    Replies: 3
    Last Post: 03-04-2016, 10:13 AM
  2. Replies: 3
    Last Post: 02-23-2015, 11:57 AM
  3. VBA to check if Data Has Changed
    By jo15765 in forum Programming
    Replies: 2
    Last Post: 11-14-2013, 03:09 PM
  4. Replies: 5
    Last Post: 07-26-2012, 09:42 PM
  5. Find out changed data
    By Papote in forum Programming
    Replies: 1
    Last Post: 04-27-2009, 08:19 PM

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