Simple Checkbox Query

[JM79]

I have a checkbox in my subform.

if I check it true I want it to copy the values of a field in the form to a field in the subform

Why isnt this as easy as

Private Sub copy_caller_Click()

If caller_copy = True Then
subformcaller.Value = formcaller.Value


End If
End Sub


TIA

 

[llkhoutx]

Private Sub copy_caller_Click()

If caller_copy = True Then
subformcaller.Value = formcaller.Value


End If
End Sub

should be

Private Sub copy_caller_Click()
If forms!MainFormname!caller_copy = True Then
  Me!subformcaller = forms!MainFormname!formcaller
End If
End Sub

Or on the copy_caller_AfterUpdate event

Private Sub copy_caller_Afterupdate()
If forms!MainFormname!caller_copy = True Then
  Me!subformcaller = forms!MainFormname!formcaller
End If
End Sub

Remember checkboxes have three values, Null, True and False. Always check against True to avoid interpretation of Null. Null and False checkbox values have different Backcolors.