Charlotte Foust
cfoust at infostatsystems.com
Mon Apr 4 19:45:21 CDT 2005
You can't do it simply, Darren. When you click the button on the parent form, the subform record is saved automatically, so undo is no longer available. The way I have done this in the past is either with an unbound subform which can be cleared, by deleting the subform record, or by storing the current value of each field to the field's tag property and then overwriting the new value if the decided to "undo." Charlotte Foust -----Original Message----- From: Darren DICK [mailto:d.dick at uws.edu.au] Sent: Monday, April 04, 2005 4:32 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003: Undo Changes to a subform Hello all This should be simple :-)) If I type me.undo and attach it to a button on a form I can undo edits to a record. If I have a main form that has a sub form in it and if I attach code something like Forms!MyForm!MySubForm.Form.Undo to a button on the main form with the intention of Undo-ing any edit to the sub form it doesn't seem to work How do I undo edits to a sub form from a button on the parent form?? Many thanks Darren -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com