I have a form (frmClient) which includes a locked textbox txtLastModifedBy which is bound to tblClient.LastModifiedBy.
When other controls on the form are updated, the form's BeforeUpdate event triggers some code which includes the line
DoCmd.RunSQL "UPDATE tblClient SET...