Can Control button change value of query

  • Thread starter Thread starter Iwilfix
  • Start date Start date
I

Iwilfix

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.
 
In the field where you change the month to filter the
list, use this in the same line. [Enter Month] Include
the brackets. I think it's called a parameter query. When
you click the button a message box with come up. Then
enter the month which will dynamically go into the query.
And bring up you results.
 
Back
Top