- Joined
- Apr 13, 2012
- Messages
- 8
- Reaction score
- 0
Hello-
I have 5 comboboxes in a form that are used to filter another form (off of a query). I want to have a button added that the user can click to clear all the selections in the boxes.
I tried putting in a button and in the "on click" event the following code:
Private Sub Command51_Click()
Me.cboFranchise.Value = ""
End Sub
The row source type for each combobox is a query.
Thanks!
I have 5 comboboxes in a form that are used to filter another form (off of a query). I want to have a button added that the user can click to clear all the selections in the boxes.
I tried putting in a button and in the "on click" event the following code:
Private Sub Command51_Click()
Me.cboFranchise.Value = ""
End Sub
The row source type for each combobox is a query.
Thanks!