I have a main form, attached to which is a subform.
When a new record is created in the subform that record has it's [Data checked by] column blank.
The [Data checked by] field is locked intentionally.
I want to be able to update it in code which is easy enough to do, but only when the "Checked"...