Help with form controls

spalmateer

Registered User.
Local time
Today, 15:13
Joined
Dec 5, 2000
Messages
46
I have a checkbox and a combobox on my form. I would like the user to be able to choose a selection from the combobox , resulting in the checkbox being checked. Also if the checkbox is unchecked by the user, I would like the form to clear the entry in the combobox. Thanks for any help with these problems!
 
Just put these two functions on your form in the AfterUpdate event of the combo box and the Click of the checkbox.

Private Sub chkBox_Click()
If Me!chkBox = False Then
Me!cmbBox = Null
End If
End Sub

Private Sub cmbBox_AfterUpdate()
Me!chkBox = True
End Sub

Where chkBox is your Checkbox and cmbBox is your ComboBox. Hope that helps.

Doug
 

Users who are viewing this thread

Back
Top Bottom