Refreshing a form

[ocp&mcsd]

Hi all,
How are you?
I have a small problem...
I have a form with 3 textboxes and 1 button. When filling these textboxes, and clicking the button, a record will be added to a table. I want when I click the button, the record to be added to the table with removing the the old record from the 3 textboxes for the new record to be added.

How can I do that??

 

[Michael J Ross]

I do it by closing and reopening the form after saving the record, to the user it looks like the form is being refreshed.

 

[ocp&mcsd]

I do it by closing and reopening the form after saving the record, to the user it looks like the form is being refreshed.

I know that...

But I want to do it without closing and reopenning...

 

[Michael J Ross]

Create a macro (SetValue) to set the value of each of the text boxes to null and use DoCmd.RunMacro after the save on the on click event of your button?