Passing parameter between 2 reports

[Stephm]

Hi. PC Datasheet showed me how to use an input form to
pass the parameter from one report to the next (using one
query). Very cool!

Now I want to share information between 2 reports, put
I'm not using an input form. Rather I'm using [Reference
date for Renewals: (MM/DD/YY)] to get the user's date.
I'm also using this same information in a DateDiff
calculation:

Expr1: DateDiff("m",Max(MembershipType.DateOfLastRenewal),
[Reference date for Renewals: (MM/DD/YY)],True)

(I did try to use input form DateParam with unbound field
FindDate, but I couldn't make it work with DateDiff).

So, the question is can I still pass the "parameter" from
one report to the next? As is, the user has to re-enter
the "reference date" on the 2nd report, which is tedious
and would no doubt lead to inconsistencies. Thanks for
your help, Steph

 

[Duane Hookom]

Use a reference to a control on a form. What happened when you tried to use
it in DateaDiff()?

 

[Annie]

Thanks for the reply- I just had my syntax messed up.
Annie

-----Original Message-----
Use a reference to a control on a form. What happened when you tried to use
it in DateaDiff()?

--
Duane Hookom
MS Access MVP

Hi. PC Datasheet showed me how to use an input form to
pass the parameter from one report to the next (using one
query). Very cool!

Now I want to share information between 2 reports, put
I'm not using an input form. Rather I'm using [Reference
date for Renewals: (MM/DD/YY)] to get the user's date.
I'm also using this same information in a DateDiff
calculation:

Expr1: DateDiff("m",Max (MembershipType.DateOfLastRenewal),
[Reference date for Renewals: (MM/DD/YY)],True)

(I did try to use input form DateParam with unbound field
FindDate, but I couldn't make it work with DateDiff).

So, the question is can I still pass the "parameter" from
one report to the next? As is, the user has to re- enter
the "reference date" on the 2nd report, which is tedious
and would no doubt lead to inconsistencies. Thanks for
your help, Steph

.