I need a Form button to open and pass two variable values to a re

Some while ago I set up a form with 7 buttons, each opening an individual
report based on an individual query.

Essentially the reports & queries are identical except for their title and
data from two table fields.

Since the form buttons determine which report I want to view, it would seem
sensible for each button to pass a different value for a common variable to a
single report. In turn the report can call a single query to extract the
right data from table.

The variable only needs values of 1 to 7. I need then to draw 1 of 7 report
titles from a table and identify to the query that along with data fields
common to all 7 reports it should include one particular pair of fields from
7 pairs.

I can't seem to get the variable recognised within the 'On Click' button
event procedure. Perhaps i'ts the wrong place or the wrong code!

The pairs of data fields in both query and report are called "AC1IN"
AC1OUT", "AC2IN" etc. I need to be able to insert my variable value between
"AC" and" IN" (or OUT) to establish the correct field name in order for it to
work.

Any help would be most welcome

Pete

If you're using ACCESS 2002 or a later version, you can use the OpenArgs
argument of the OpenReport method to pass a value to the report, and then
read the OpenArgs property in the report's Open event procedure.
--

Ken Snell
http://www.accessmvp.com/KDSnell/



"Parish Pete" wrote in message
...
Some while ago I set up a form with 7 buttons, each opening an individual
report based on an individual query.

Essentially the reports & queries are identical except for their title and
data from two table fields.

Since the form buttons determine which report I want to view, it would
seem
sensible for each button to pass a different value for a common variable
to a
single report. In turn the report can call a single query to extract the
right data from table.

The variable only needs values of 1 to 7. I need then to draw 1 of 7
report
titles from a table and identify to the query that along with data fields
common to all 7 reports it should include one particular pair of fields
from
7 pairs.

I can't seem to get the variable recognised within the 'On Click' button
event procedure. Perhaps i'ts the wrong place or the wrong code!

The pairs of data fields in both query and report are called "AC1IN"
AC1OUT", "AC2IN" etc. I need to be able to insert my variable value
between
"AC" and" IN" (or OUT) to establish the correct field name in order for it
to
work.

Any help would be most welcome

Pete

Thank you Ken, I'll try and get my head round OpenArgs

Let's hope I don't turn it into Open AAArghs!

regards

Pete

"Ken Snell" wrote:

If you're using ACCESS 2002 or a later version, you can use the OpenArgs
argument of the OpenReport method to pass a value to the report, and then
read the OpenArgs property in the report's Open event procedure.
--

Ken Snell
http://www.accessmvp.com/KDSnell/



"Parish Pete" wrote in message
...
Some while ago I set up a form with 7 buttons, each opening an individual
report based on an individual query.

Essentially the reports & queries are identical except for their title and
data from two table fields.

Since the form buttons determine which report I want to view, it would
seem
sensible for each button to pass a different value for a common variable
to a
single report. In turn the report can call a single query to extract the
right data from table.

The variable only needs values of 1 to 7. I need then to draw 1 of 7
report
titles from a table and identify to the query that along with data fields
common to all 7 reports it should include one particular pair of fields
from
7 pairs.

I can't seem to get the variable recognised within the 'On Click' button
event procedure. Perhaps i'ts the wrong place or the wrong code!

The pairs of data fields in both query and report are called "AC1IN"
AC1OUT", "AC2IN" etc. I need to be able to insert my variable value
between
"AC" and" IN" (or OUT) to establish the correct field name in order for it
to
work.

Any help would be most welcome

Pete


.