Have form refresh for new data entry

  • Thread starter Thread starter Jason
  • Start date Start date
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
 
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)
 
Back
Top