Solved

Undo Changes in a subform record

Posted on 2009-07-09
3
348 Views
Last Modified: 2013-11-28
I have a parent form with a child form, the Undo button is located in the parent form. I need it to reset the record to whatever has been committed last ignoring all un-saved changes.
I tried
Me.Undo
but it ends up saving the changes.
0
Comment
Question by:MariamAlsowaidi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24812735
Hi Mariam,

Try putting the button in the subform. or something like Me!subformname.form.undo


Gary
0
 

Author Comment

by:MariamAlsowaidi
ID: 24812769
It worked once I put it in the subform, it didn't work when I used the other method though.

Thanks
Mariam
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24812786
The problem is probably that as soon as you go from the subform to the mainform it updates.
Glad to help!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question