Enable CheckBox with ComboBox

[tizzie]

I need to enable a CheckBox(Jan) based on the selection of a ComboBox (Combo454) in Access 2010. The results I want is that when the answer of "Yes" is selected from the ComboBox then the CheckBox for the month of January will automatically be checked

I've tried several code combination, the following being the last of many the still have not worked:

Private Sub Combo454_AfterUpdate()
If Combo454.Value = True Then
Jan.Enabled = True
 
Else: Jan.Enabled = False
End If

[Seth Schrock]

It depends on how you have in the row source for your combo box. If you just have the text "yes" and "no", then you would need the following code:

If Me.Combo454 = "Yes" Then
    Me.Jan = True
Else
    Me.jan = False
End If

If you have a table complete with a primary key, then you would test on the PK value.

Just curious, are you wanting to change the Enable property of the checkbox, or just whether it has a check mark? Your question leads me to believe the latter, but the code leads me to believe the former.

[tizzie]

Thanks. Will give this a try. You are correct, I just want the box to reflect a check mark in it when the combobox answer is Yes.

[tizzie]

Thanks so much. Worked like a charm.

[Seth Schrock]

Great! Glad I could help.