Reset Form

[stang289hp]

I have a form that I use to input data into a table. This form has a
dozen fields to fill in ( 2 of them are Combo_Box's). The first and
last fields are required fields. Data Entry is set to "yes" in the
form properties (so that when launched it's at a new record). What I
am trying to do is create a CANCEL button on this form which will
clear the form and start it as new (without saving it). Trouble is,
with the required fields, it creates an error and will not let me
accomplish this.
Any suggestions would be greatly appreciated ??

 

[mscertified]

Did you try hitting the ESCAPE key and see what happens?
This should trigger the Form Undo event, where you can take whatever actions
are needed.
Of course you can trigger this event from your Cancel button also.

-Dorian

 

[stang289hp]

Did you try hitting the ESCAPE key and see what happens?
This should trigger the Form Undo event, where you can take whatever actions
are needed.
Of course you can trigger this event from your Cancel button also.

-Dorian





- Show quoted text -

Ya know, I could have sworn I tried that and it didn't work...but upon
trying it again it works. Thanks' Dorian