Filtered Forms

Topic

New Reply

Office 97 SR2.

I have a command button that opens a form, filtered. What can I do in VBA to remove this filter? Ideally, When the user clicks on a search button, the filter would be removed. Any ideas?

Thanks!

Reply | Quote

Replies

How about: RunCommand acCmdRemoveFilterSort

Never tried it myself, and I don’t know if it just removes the Sort or the Filter & Sort.

Reply | Quote

How about

Private Sub Command11_Click()

Me.Filter = “”

End Sub

John Graves

Reply | Quote

It depends on where you applied the filter in the first place. If you applied the filter to the form, use the form’s filter property and set it to an empty string (“”) or set the form’s FilterOn property to false. If you do the latter, you can reapply the existing filter if you want to by setting the FilterOn property to true.

Reply | Quote