Check boxes on separate forms

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??
 
G

Graham R Seach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To check all items in a subform 10
Form/Subform Question 2
Change value is form based on value in subform 1
Subform clear data 2
Update (refresh) Subform#1 when a check box is selected on Subform 8
Check Boxes 1
Using Linked Combo Boxes with a subform 1
Set Change Event on Control from Nested Subform 0

Top