Affichage des articles dont le libellé est Clear only one filter. Afficher tous les articles
Affichage des articles dont le libellé est Clear only one filter. Afficher tous les articles

Clear only one filter

mardi 17 mars 2015

I've seen code similar to below that clears all filters, but is it possible that instead of clearing all filters, I can clear just a specific one?





Private Sub cbGroup_Click()

Me.cboUnitName = Null

Me.cboGroup = Null

Me.tbl_users_subform.Form.Filter = ""

Me.tbl_users_subform.Form.FilterOn = False

Me.tbl_users_subform.Form.RecordSource = "tbl_users"

Me.tbl_users_subform.Requery

End Sub

Clear only one filter

Labels