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 cannot 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
work.

Any help would be most welcome

Pete

If you are using ACCESS 2002 or a later version, you can use the

If you are 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/

Thank you Ken, I will try and get my head round OpenArgsLet's hope I do not

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

Let's hope I do not turn it into Open AAArghs!

regards

Pete