Fields do not Empty

pepegot

Registered User.
Local time
Today, 15:49
Joined
Feb 20, 2006
Messages
39
I have an Input form that does not clear the fields after I hit the Save button. Data Entry is set to YES. If I use the navigation bar, there is no problem, but I would like to have the fields empty after hitting the Save Button, so that the navigation bar can be removed. What is wrong?
 
Do you want to add a new record after the save command? If so then add the following after the save command:

Code:
DoCmd.GoToRecord , , acNewRec
 
Yes, but where? In the error code attached to the save command, perhaps? What is the context?
 
Last edited:
Do you have a button on your form that is clicked to save the record or do you just use the Access Menus?

If the former add it to the code in the on_click event of the button, if the latter then add it to the After_Update event of the form
 
Fields do not empty

Thank Yoooou!!!! It was just what I needed.
There must be similiar code that will clear the input screen after data entry when Data Entry (Yes) fails to work? Something with a new record or so, but I don't know the code.

Something like, Me.formname = Me.newrecord, or something?
The (DoCmd.GoToRecord , , acNewRec) looks like it needs more code, or would it work in the error code? Just putting anywhere, on the save button, by itself seems not right.

Could you help?
 
Last edited:

Users who are viewing this thread

Back
Top Bottom