filter

[mdelo]

I would like to place code behind a button that will open the filter by form page. I don't want to have the user click on the Access buttons to get to this page, i.e. I would like to use command buttons on the form to open the FBF page and apply whatever filter is entered by the user. The filters will not be saved filters because there are not any that are needed on a regular basis. Does anyone know how to code something like this?

 

[Travis]

The following code will allow you to Filter by Form, Filter by Selection, or Filter by Excluding

DoCmd.RunCommand acCmdFilterByForm

DoCmd.RunCommand acCmdFilterBySelection

DoCmd.RunCommand acCmdFilterExcludingSelection

There are many Toolbar functions that can be called using the Docmd.RunCommand Function.

HTH