New Form Button

bluedigital

Registered User.
Local time
Today, 12:39
Joined
Nov 21, 2007
Messages
20
How do I create a button that saves the current record, and then clears all the fields so that a new record can be entered?
 
If your form is bound to a query then it will do this automatically when you move off the current record.
 
not bound

My form is not bound to a query. It is simply an entry form with a submit button. My current submit button simply saves the record, but the current data stays in the fields. I just want the form to clear after they hit the submit button, so another record can be entered immediately after.
 
Then if you want to clear field you can use:

Me.YourControlNameHere = ""

for checkboxes:

Me.YourCheckboxNameHere = False
 

Users who are viewing this thread

Back
Top Bottom