I have been trying to write a small program that would allow me to filter
my records in a form for Access 2.0. I am getting a Parameter Input Box
popping up when I run this module and I would like to automate the
parameter by having the user indicate a limit in an unbound combo box
prior to filtering. Here is the portion of the program in question:

Sub Search_Click ()
[Year] = Y
[Type] = T
[GTE] = GTE
[Number Query] = Q

Select Case T
    Case Applications
            DoCmd GoToControl "Applications 95"
            DoCmd ApplyFilter , "[Applications 95] > ""[Number Query]"

End Select

End Sub

The [Number Query] value is set before the user submits the filter
request; however, a parameter box pops up and requests that the user enter
in the limit for a second time. I would like to use the ApplyFilter
command properly, but I don't have a comprehensive resource to fully
understand its usage. If you could steer me in the right direction, I
would appreciate it very much.

Thanks,
Kevin
--
______________________________________________________________________________
Kevin M. Riordan                "One should follow the wise, the intelligent,

                                the noble; one should follow a good and wise
                                man, as the moon follows the path of the stars."