I have Office 365 on Windows 10.
To start off, I have my database in a user defined trusted location. I even have the Macro security setting set to always allow.
I have a Form Refresh button defined on my form using the Command Wizard. It functions properly, until I add an event procedure for After Update to the form. The event procedure very simply updates a field in the record, based on two other fields in the same record.
Private Sub Form_AfterUpdate()
Mem_Name = Surname & ", " & Given_Name
End Sub
If I attempt to go to the next record after editing a name field, I am told "You cannot go to that record".
If, instead, I select the refresh button, I get the following error:
Macro Name: SCATeam : Refresh: OnClick : Embedded Macro
Action Name: RunMenuCommand
Error Number: 2950, Arguments: 18
And the form no longer functions properly, forcing me to close it and reopen it. Even with the error, the event procedure completes the update.
If I do not edit a name field, the refresh, or go to next record, both work just fine. If I get rid of the After Update procedure, everything works fine, even when I edit a name field, but, of course, the update of the target field doesn't happen.
Why is this happening, and how can I get it to work?