Custom button click to Built-in pop-up filter

[LindaRuble]

Hello, I have managed to click on a custom button to bring up the built-in pop-up filter, however, you need to
set focus on (place your cursor in) the field in the record set of the report that
you want to filter before clicking the button with the following "on click" code:

Private Sub FINANCIAL_PRD_Click()
Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFilterMenu
End Sub

I would like to be able to just click a button without having to place my cursor in a


field of a record set to get this pop-up filter. I would also like to specify the
information I am getting perhaps with a query such as "SELECT column_name(s)
FROM table_name"


Here is an picture of what I am trying to do

http://www.printandpixel.com/access_filter2.jpg

Any help would be greatly appreciated.
Linda

[June7]

Cross post http://forums.aspfree.com/microsoft-...up-535613.html