variable dates to appear on a report

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
 
T

tina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date interval report 0
access 2010 date field 4
Open filtered report 8
Show Parameter Information in Report Footer 1
print a date range from parameter query on a report header? 2
Records Appear In the Query, But Not On the Report. 5
2 queries, a date range and a report?! 3
Record Source not showing field names 4

Top