Using the expression builder to determine whether a check box is ticked or not

[isladogs]

As this is from the main form & only one control is on the subform then it should be

Private Sub Form_Current()

    Me.[Cog signatory the same?]=Me.[2017-18 data subform1].[Form]![Full name of person who agrees to the terms of the Conditions_01]=Me.[name on form]


End Sub

Or

Private Sub Form_Current()

     If Me.[2017-18 data subform1].[Form]![Full name of person who agrees to the terms of the Conditions_01]=Me.[name on form] Then Me.[Cog signatory the same?]=True

End Sub

Or follow June's suggestions

BUT PLEASE RENAME YOUR FIELDS, FORMS, CONTROLS & LABELS .....

[Fostertrident]

Thank you June that works a charm. Many thanks.

I'm sorry about the lack of renaming, it's because a lot of my data is coming from a linked table which in turn comes from an online form.

There's a lot of columns in there so haven't look at how to do this yet.


Thanks for your help and sorry for being ignorant about a lot of things. Made good progress today.