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

  • Thread starter Thread starter Parish Pete
  • Start date Start date
P

Parish Pete

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.
 
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
 
Back
Top