Oh no the naming gets even worse !!!!!!
Each time you use a space or special character such as '?' in your database, you have to enclose it in square brackets [] and the chances of making typo errors increases dramatically
Its also MUCH HARDER to read the code when you have such long-winded names
Assuming the checkbox is on the MAIN form, use a Form_Current event on the MAIN form
1. Using Ranman's approach
Code:
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.[2017-18 data subform1].[Form]![name on form]
End Sub
or with better naming, something like
Code:
Private Sub Form_Current()
Me.chkSigSame=Me.fsubData.Form.txtFullNameTC=Me.fsubData.Form.txtFName
End Sub
The way these both work is that if the 2 textbox values are equal, the expression is true & the checkbox will be true (and vice versa)
2. Or use If ... Then (NOT IIf) (again using the shortened versions)
Code:
Private Sub Form_Current()
If Me.fsubData.Form.txtFullNameTC=Me.fsubData.Form.txtFName Then Me.chkSigSame=True
End Sub
3. If the checkbox is in the subform then use this in the subform Form_Current event
Code:
Private Sub Form_Current()
Me.chkSigSame=Me.txtFullNameTC=Me.txtFName
End Sub
OR ....
Code:
Private Sub Form_Current()
If Me.txtFullNameTC=Me.txtFName Then Me.chkSigSame=True
End Sub
Good luck with your project. I think you are going to need it!