How do I clear the form when a user hits the save button?

[lconte]

I have the save button and it writes to a table but i also want it to clear the form. This form is mainly being used for data entry.

Any ideas?

 

[Remou]

Loop through the controls collection?

 

[jkl0]

DoCmd.GoToRecord , , acNewRec

Hope this helps?

 

[lconte]

THANK YOU, THANK YOU!!!! The DoCmd.GoToRecord, , acNewRec worked!