Using combo box to filter form

A

a

Thank you
I have unbound combo box with (bound form )
I want when select data in a combo box apply filter by selection to bound
form??
Note I want only the code I need to apply (((filter by selection))))
 
J

John Vinson

Thank you
I have unbound combo box with (bound form )
I want when select data in a combo box apply filter by selection to bound
form??
Note I want only the code I need to apply (((filter by selection))))
Click to expand...

The Combo Box wizard will set this up for you; or you can use code
like this in the AfterUpdate event of the combo:

Private Sub combobox_AfterUpdate()
Me.Filter = "[fieldname] = " & Me!combobox
Me.FilterOn = True
End Sub


John W. Vinson[MVP]
(no longer chatting for now)
 
Top