Query Question

Hello, I have a query that i would like to filter when i click a button on my
form, that uses a field on the form to filter the query. I do not to display
info in a report or form, or table but to export to excel. i cannot figure
out how to do this....any help would be appreciated.

Ryan

Create a form named something like frmParameter. On the form have a text box
named something like txtParameter.

On this same form put a command button and on the On Click event of the
button put:

DoCmd.OpenQuery "qryParameter"
Me.Visible = False

Create a query named something like qryParameter with the line below in the
criteria of the correct field.

[Forms]![frmParameter]![txtParameter]

The form Parameter must stay open for the query to run; however, it can be
minimized or even invisible.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Ryan" wrote:

Hello, I have a query that i would like to filter when i click a button on my
form, that uses a field on the form to filter the query. I do not to display
info in a report or form, or table but to export to excel. i cannot figure
out how to do this....any help would be appreciated.

Ryan