Combo box

G

Greg Snidow

I have made a form for tracking jobs on which there is a check box to check
if a certain condition exists on a job. Below the check box there is a combo
box with the only options being yes or no depending on whether the condition
has been remedied. I want the combo box to be greyed out or otherwise
unaccessible until the check box is "true". Does anyone know how to do this
easily, I am adept at Access.
 
B

BruceM

Assuming that the combo box is named cboYesNo and the check box is
chkCondition. in the form's Current event put:

If me.chkCondition = False then
me.cboYesNo.Visible = False
Else
me.cboYesNo.Visible = True
End If

Place the same code in the After Update event for chkCondition.
 
D

Dennis

In the forms on current event and in the after update event of the check box
put this
if CheckBoxName = True then
ComboBoxName.Enabled = True
else
ComboBoxName.Enabled = False
end if
 
Top