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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick - 26 Sep 2007 10:38 GMT

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

Reply to this Message

Klatuu - 26 Sep 2007 16:12 GMT

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

Signature

Dave Hargis, Microsoft Access MVP

> 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

Reply to this Message