My combo boxes are all activated

[david.paton]

I have a form tblChild Subform2 that has a combo box for relationship at the end. Upon selecting the checkbox, I want the combo box for that record enabled but when I select it, it activates the checkboxes for every record.

 

[June7]

Yes, the combobox will be activated for every record. This is because you are programmatically setting a property for the combobox and there really is only 1 combobox. So the property setting will be reflected in all instances of the combobox.

Use Conditional Formatting instead of VBA.

 

[david.paton]

How do I use conditional formatting to do that?

 

[david.paton]

Sweet, thanks, I worked it out

 

[arnelgp]

Use the Current Event of the subform:

Private Sub Form_Current()
on error resume next
Call chkRelated_AfterUpdatr
End Sub

 

[david.paton]

If I unselect a checkbox I want the combo box to clear. Can someone help me with that code please?

 

[NauticalGent]

On the Check Box AfterUpdate Event:

If Me.YourCheckBox = False Then
     Me.YourComboBox = “” ‘ or Null if it is a number 
End If