undo command button

[gray78]

I have a form where I would like to place a button that when clicked, it will revert the form back to it's original data.

How is this done?

Thank you

 

[jrbarnett]

Here are some basic instructions. I'm using Access 2002 (XP) here, but it may be slightly different if you are using a different version:

1. Go into form design.
2. Click CommandButton on the toolbox and drag it out in the correct area of your form.
3. With the wizard, choose Wizard Operations in the left hand column and "Undo Record" in the right hand.
4. Follow the wizard through to completion.

John

 

[gray78]

I keep getting the message "undo command not available"

What is wrong?

 

[jrbarnett]

It can only be done this way if:
1) You have a bound form
2) You have entered the new or updated information
3) This information has not yet been saved.

If not, you will need code to store the old values and restore them when clicked.

John