variable dates to appear on a report

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I have a report that I generate based on a Start and End
date option that the user enters at the time they
genterate the report. I want these dates to appear on the
report, but I can't seem to get them to prefill from the
original request form. I have the fields on the report,
but they display empty. Any help certainly would be
appriciated. Thank you
 
in the report's OnOpen event, try the following code:

Me!StartDate = Forms!FormName!Date1
Me!EndDate = Forms!FormName!Date2

enter the appropriate report control names, and the
appropriate form and form control names. make sure that
the 2 controls in the report are unbound.

hth
 
Back
Top