Filtering a Continuous Form

[kdbailey]

I'm looking to be able to filter my continuous form, but not by using the Filter and FilterOn properties of the form. If you open the form unfiltered and click into any of the fields, then on the Access ribbon click "Filter", you are given the full list of options to filter by, just as if you were on a table.

Can I achieve this same result with a command button in the header of the form? Or maybe there's even another way to achieve this.



We'll start with an example...

Column 1 is titled "Project Number" and the command button associated with that column will be titled "cmdfilterprojnum".

[June7]

Only options I am aware of for filtering a form:

1. right click menu

2. ribbon: filter and filter-by-form

3. code using Filter and FilterOn

[kdbailey]

I actually was able to figure out the following way to achieve the same ribbon filter result. I just activate a specific record since clicking the command button removes focus, and then setfocus on whichever column I want to filter.

Private Sub cmdfilterprojdesc_Click()
Me.Recordset.MoveFirst
Me.txtprojdesc.SetFocus
DoCmd.RunCommand acCmdFilterMenu
End Sub

[kdbailey]

When I filter this way, it is basically the same as the right click method. What event on the form fires after I select what I am filtering?

[kdbailey]

Nevermind, found it.
On Apply Filter