For the life of me I cannot figure it out
In my form the code in the OnCurrent Event creates Error 2465 "Application-defined or Object-defined Error"
Me!UserID = CurrentUser
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 <<<<< Bad Line Of Code
I need the form to save immediately upon opening so that the CurrentUser is saved in the record and others can see that the record is being edited.
What is befuddling is that I have a command button on the form with the same code. When pressed, the record is saved and the error is not generated.
What gives? Maybe there is another way to save the record through code that won't produce the error.