Easy one - Initialize text box to blanks

[marathonlady]

I have 2 textbox fields on a form. When I enter data in them
(these are unbound, used as parameters in a query), and open the form again, the data I entered before is still displaying in the text box. I have tried initializing to " " on Open and Activate, but get same result, ie, previous data is displaying. What do I do.

Thanks!

 

[audrey]

Do you want the txtboxes to clear after each record, after you close the form.... would you want to have a button on your form that clears the fields? When do you want the fields to clear?

 

[ghudson]

Are you sure that you are closing the form? An unbound text box will not hold the value when the form is closed and then re-opened.

You could change the value of the text boxes after the query is run. Set the text box to Null.

HTH