ACCESS FEED: RE: [MS_AccessPros] Undo (ctrl+z) using a button on a subform.

Senin, 31 Oktober 2011

RE: [MS_AccessPros] Undo (ctrl+z) using a button on a subform.

Lee-

Can't be done. The second you move the focus to the outer form by clicking the
button, Access automatically saves any changed record. If you really need to do
this, you need to design a Continuous Form for your subform (you can make it
look like a Datasheet if you like, but the columns won't be resizable - which in
some ways is good), and put the button on the header of the subform.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
Sent: Monday, October 31, 2011 5:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Undo (ctrl+z) using a button on a subform.

Hi,
I have a form with a datasheet subform. I'm trying to put a button on the main
form that will undo on the subform the way ctrl+z does. I've tried the
following in the on_click event of the button:

Me.fsubForm.Form.Undo

however it doesn't do anything, even though Me.undo will undo the most recent
change to the form. What am I missing?

Thanks
-Lee

------------------------------------

Yahoo! Groups Links