Hi. In Access I want to commit data to table as if user had clicked the next "New" record in a tabular form. What VBA would I use?
I already tried to move to the next record with the following code but I got an error saying that I could not move to the next record.
DoCmd.GoToRecord , , acNext