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)
 
Top