how to refresh text box in form screem

[newaccess]

Hi Experts,

I have an inserted data form at access 2007. It works.

But The added data is still exist in text box after data inserted.
I added Me.Refresh to refresh it. But is does not work.

Do we have any way to clear "old added data" from input test box?

Thanks very much!
NewAccesser

 

[boblarson]

Me.Refresh has nothing to do with it. You might want to read the help file to know exactly what refresh and requery both do.

If this text box is an unbound text box you can set it back to null:

Me.YourTextBoxNameHere = Null

or to an empty string

Me.YourTextBoxNameHere = vbNullString

depending on your needs.

If it is bound, changing it to null or blank will affect the field that it is bound to.

 

[newaccess]

Thanks very much. works!