Passing Values into Reports

  • Thread starter Thread starter ExcelMan
  • Start date Start date
E

ExcelMan

I need to pass a starting value into a report -- in this case a date.
I tried using DoCmd to open the report and passing the value in the
OpenArgs parameter. But when I went into the Report_Open event the
Me.OpenArgs value was NULL.

Does the OpenArgs parameter work for reports? The documentation I've
seen thusfar only covers Forms. Is there a better way to pass a
starting value into a report? I know I could store the value in a
little table, then use a query or DLookup to retrieve the value during
Report_Open, but I'm looking for a little cleaner approach if possible.

Thanks.
 
A2003 supports the OpenArgs for reports but I don't believe that earlier
versions do.
If the field you want exists on the form you use to open the report, you can
get the value from there:
=Forms!YourForm!SomeField
 
I have the same issue. The problem is that I want to use the same report
from different forms rather than generate a report that is looking for the
specific form that called it.

Thanks in advance....Ellie
 
Back
Top