Check boxes on separate forms

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

I have a form with 3 subforms. I have checkboxes on 2 separate
subforms. Is there a way that if a user clicks the checkboxes on one
subform, it can have the checkboxes on the other subform check and
uncheck relatively. I tried doing the normal code in the 1 subform and
if i check on box, the other box won't check unless i click inside of
its subform. Any idea as how to make this work??
 
Private Sub chkMainFormCheckbox_Click()
Me.SubformName!chkSubform1Checkbox = Me!chkMainFormCheckbox
Me.SubformName!chkSubform2Checkbox = Not Me!chkMainFormCheckbox
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
Back
Top