command button to undo changes

[FormNewbie]

I have a main form that contains a subform. The subform
is a datasheet that allows entry of new rows of data. If
the user creates an entry by mistake, is there a way to
create an "undo" command button that will reset the form
and subform data to the way it was before the user entered
the data?

Right now, I think they have to use ESC button to clear
fields, but some of them don't know to use it. They get
stuck in the form.

Hope this makes sense.

Thanks

 

[Roger Carlson]

The command button wizard has an Undo Button option. Choose Record
Operations and then Undo Record and follow the wizard prompts.

 

[FormNewbie]

Hi Roger,
I tried the command button wizard, and tried all 3
options - (Eraser, Undo, Undo(rewind)). All 3 of them
gave me the same error - The command or action 'Undo'
isn't available now. Do you know how I can fix this?
Thanks.

 

[Roger Carlson]

When the focus moves from a form to a subform, the record in the form is
Saved. This means it can no longer be Undone. It must be deleted. So
maybe instead of Undo, you should Save, then Delete the record.

 

[Guest]

Thanks, Roger. I got it now.

-----Original Message-----
When the focus moves from a form to a subform, the record in the form is
Saved. This means it can no longer be Undone. It must be deleted. So
maybe instead of Undo, you should Save, then Delete the record.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org




.