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.

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

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

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