Filtering?

[mohsinhq]

Is there a command button that can be created to filter by form? i had a look in the wizard but its not there..

or even the vba code would be useful

thanks

 

[ray705]

I’m not sure if this is what you are thinking.
I have one that will filter the form after selecting a value in a combo box.

Private Sub cbDept_AfterUpdate()
DoCmd.ApplyFilter , "[HomeDept] = '" & Me![cbDept] & "'"
End Sub