Can control button change query values?

[NQBoomer]

I have a table with a list of clients with a field dividing them into months.
( 1 for Jan,2 for feb,etc). Once a month I need to print a list report with the
associated clients for that month.
I use a query to filter my table, But of course have to change the value of
of the field each time.
I use a control button on a form to print the report obtained from the query.
I could use 12 buttons and 12 queries for this purpose, but this is so
redundant and cumbersome
Is there a way to modify the query by just by hitting the control button?
In other words " Press Print", parameter window " Which month?"

As always, thanks in
advance Jeff V.

 

[John Vinson]

Is there a way to modify the query by just by hitting the control button?
In other words " Press Print", parameter window " Which month?"

Sure. A Parameter Query.

If your form is named frmLaunch, try putting a combo box or an option
group control on the form so the user can select (rather than type) a
month - this has the advantage that you can display the month *name*.
A simple Option Group control with twelve radio buttons, labeled Jan,
Feb, Mar etc. would do it.

Your query criterion would be

=[Forms]![frmLaunch]![optMonth]

or whatever the name of your control might be.