clearing data entry form

[mghdb]

Hello -
I have a form that is used for data entry into a table. I would like to have the the text boxes and combo boxes clear once the user clicks on the "Submit" button. What I have now doesn't work. When a user goes into the form, the last entry is displayed. Can anyone help me in figuring this out. Thanks in advance.

 

[Chris RR]

This is just off the top of my head, but I think that, in the code behind your "submit" button, add something like this (after you've done all your other processing):

' change Field1 and cboField2 as needed...
me.Field1 = Null
me.cboField2 = Null
me.requery

 

[mghdb]

thanks for you quick reply...i'll will give that a try.

 

[novabill]

Thats easy, just create a macro with the first action opening your form and the next action a "go to record" and in the gotorecord action arguments Record line chose "new". This will cause your form to start with a new fresh blank record every time the user goes to the form to enter new data