OnClick Event submit and clear

[Desstro]

I would like to add a button to a form that when clicked the data entered into the form is posted to the table and then the data is cleared for additional data to be entered.



What would that code look like?

[NTC]

Its additional work to undo what is normal in a client/server environment where bound forms are live data. But it is also a common request - particularly since people are accustomed to web sites which essentially are store/forward methods.

You can skin the cat a couple ways; use a regular bound form so the data is being saved live - advance to a new blank record with a 'Save' button that just is a new record button. It is all a facade of course....but you would need an unsave method obviously if they don't advance which you can do....using perhaps the Undo Event of the form.

Another way is a totally unbound form; then trigger an insert query, and clear all those fields.

but plain ole bound forms with normal record selection is pure & simple.....I've talked quite a few clients out of the 'save' mentality.....

hope this helps.