Resetting textbox values to blank after new record is added i.e. h

[Nick]

Hello

Can anyone tell me how to code my command button to reset textbox values to
blank after it has completed updates to tables?

Many thanks in advance and kind regards, Nick

 

[Klatuu]

If your form is a bound form, that will not work. If you change the value of
a text box, it will change the value for the field bound to the text box.
You can, however go to a new record.

Docmd.GotoRecord acNewRec