Text Box Update To NULL Value

[mpdavidson]

I am currently working in MS access and have a form with 3 unbound textboxes on it. These textboxes feed their information into a table via an append query. I have a button that runs this query and feeds the information to the table as I planned, but I cannot get the textboxes to update to a null value after I click the button. Is there someway I can do this without having to close and then reopen the form?

[jamesd0142]

if i understand your query correctly...

text1.text = ""

[QVeen72]

Hi,

What code u have used to populate data to textbox...?

REgards
Veena

[mpdavidson]

The Textboxes are manually updated by the user. The information that the user inputs get appended into a table through an update query.

[mpdavidson]

Got it! I just worte:

me.textboxname = null

Autoupdates to null values after i click the button. Thank for the help