Refreshing form back to blank

[CP611]

I have made a form where people can press a button (Add new record), filll in the required fields and then press Submit (the form operations, and refresh form data). Which adds in the new record fine, is there a way to make the form then go back to being blank once they have submitted their information! I am a complete beginner with Access so not really used to all the coding elements! thank you

[Micron]

Try this somewhere in your code: DoCmd.GoToRecord , , acNewRec
Probably just before the End Sub line. Can't be specific unless you post your code. If you do post code, please use code tags (# button on posting toolbar) for more than a few lines.

[CP611]

HI there, I haven't really used code, I just added in a button from the task bar. Where would I find this code to add the section in your mentioned? Thanks

[Micron]

Sorry, not following. By task bar you mean Ribbon? I'm guessing you are using macros to do what you've accomplished so far. If using macros, add the action to go to a specific (new) record. I'd have to research how to do that because I rarely use macros. If you want to post a db, copy your db, compact/repair it and if OK, zip it and post here. See how to attach files at the top of this page.

[Micron]

Found it (assumes this is what you're doing/need). Click Add New Action drop down in your current macro. Find GoToRecord and fill out the parameters. If this isn't what you need and you're not using code then I have no clue as to what you've created so far.

[CP611]

That's worked, thank you

[Micron]

Glad I could help. When you have a solution, please mark your thread as solved to save others time. See "Thread Tools" at the top of your first post.