Have form refresh for new data entry

J

Jason

I have a form that I will be using to add data to my
table. I want the command button to save the current
record and refrsh the form for anohter record. I've tried
this code but it is not working, any suggestions.

DoCmd.Save
DoCmd.GoToRecord New
 
R

Rick Brandt

Jason said:
I have a form that I will be using to add data to my
table. I want the command button to save the current
record and refrsh the form for anohter record. I've tried
this code but it is not working, any suggestions.

DoCmd.Save
DoCmd.GoToRecord New
Click to expand...

DoCmd.RunCommand acCmdRecordsGoToNew

(you don't need a save as that is automatic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Adding data to MS Access from csv file 0
How do I clear a form? 0
Copy previous record into form field 0
insert sql form-subform problem 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Space at end of multi page list to accommodate new entries 1
Crating User Form to Add Names 1

Top