Ha! It turned out to be, as a suspected, a small error that was easily fixed.
I was logged into the wrong SQL Server BE (Dev) which I don't have write access to, instead of Test, which I do.
Ajax reply got me to relink all my tables, but this time to Test. The record now saves correctly. The Write Conflict error message sent me down the wrong rabbit hole.
davegri: Here's the On Dirty event, but now its a moot point.
Code:
Private Sub Form_Dirty(Cancel As Integer)
Me.UserID = gblInitials
Me.LastUpdated = Format(Date + Time(), "mm/dd/yy hh:mm")
End Sub
Thanks to you both for lending a hand.