Using combo box to filter form

[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))))

 

[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))))

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)