Ok. Just summarize what you have done so far.
The update query, from my view would be a stand alone operation, but I may have missed or forgotten some of your background.
You would not need the
DoCmd.GoToRecord , , acNewRec
If you are clicking a button or some other event, then your update query could be triggered by the event.
It isn't common to name fields in a table as column2 or column7 etc.. Columns in tables (fields) would normally have names such as Status, or EmployeeFirstName etc.
Your reference to me.combo14 indicates a control on a form, and that form must be open when the query is executed.
Have you backed up your database? Update queries can be unforgiving!!!!