Clear/ Reset form button?

[gomikem]

I have an order form with a sub-form for each item in the order. Because this form writes to a few different tables, a lot of the fields are primary keys of a table. Due to these circumstances, if the user tries to click off of the sub-form, it won't let them go anywhere without filling out all of the required fields. If they make a mistake, they have to close the form and re-open it... going through a few alert boxes on the way out...

Is there any way that I can create a button on the sub-form to reset the form without submitting the data?

Once any data is entered, even if it is deleted, we have the same problem.

Thanks for any help.

 

[rainman89]

check out ghudsons "a better mouse trap". it should be in the samples DB he has a save/undo button that you can modify to fit your needs

 

[gomikem]

I will check that out. Thanks!