cancel button

[gray78]

I have a simple for and want to put in a cancel/reset button in. When clicked it will not store the data and will set the fields (4) back to their previous state.

Can anyone help??

Thanks

 

[traingamer]

See thread702-1027702 posted earlier today, among other threads.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[gray78]

Looking for an easier solution than that, just want a button that resets the form.

Can this be done?

Thanks

 

[hkaing79]

Me.Undo?

If that doesn't work, something like

Dim ctl as Control

For each ctl in Me.Controls
ctl = "" 'or ctl = null
Next