Combo Box to retain values

[paulcraigdainty]

I have three combo boxes (name, team and activity) and a text box (comments)on my form. When the user has selected their name, team and activity and then entered relevant comments they click save this then saves the reord to the table. I have used the following statements as on click events behind the save buttonoCmd.RunCommand acCmdSaveRecord and DoCmd.GoToRecord , , acNewRec

Currently this saves the record to the table and resets the form so the user can enter another activity. I don't want the name and team combo boxes to reset. I want them to retain the value from what was last entered, can someone help me with the additional VBA. Thanks