Clear Form

[Mahira]

Hello, I am new to the forum and fairly new to Access. And I inherited this database.

I'd first like to thank you all for the very helpful information I've found so far!

I actually have a couple of problems with this registration form. First off, I can't get it to clear all the fields when a person clicks the 'Submit' button. The selections made in the list boxes will clear, but the information typed in by the user will not. I know it is probably something simple that I'm missing.

Thank you for any help you can provide.

 

[rainman89]

have u tried me.refresh?
or in the onclick go
docmd.gotorecord acnewrecord

 

[jkl0]

DoCmd.GoToRecord , , acNewRec

Will take you to a new blank record.

 

[Mahira]

It worked...thank you both!!

 

[rainman89]

glad to hear you figured it out