I have a Report who's record source is determined by the selection users make in the corresponding Report Selection Dialog box. The same Dialog box also requires users to select [ReptBegin] and [ReptEnd] dates. The report is grouped by the [ReferralSource] field and a page break is forced after the end of each section (since I need to distribute individual reports to each Referral Source).
Here's my problem - I inserted a text box to display the Date Range of the Report as follows: =[Forms]![frmReportSelectionDialog]![ReptBegin]&" to "&[Forms]![frmReportSelectionDialog]![ReptEnd]
The expression evaluates correctly on the first page of the report (the first Referral Source section) but displays "#Error" on all subsequent pages.
Any ideas? This is really driving me crazy!
FranD
Here's my problem - I inserted a text box to display the Date Range of the Report as follows: =[Forms]![frmReportSelectionDialog]![ReptBegin]&" to "&[Forms]![frmReportSelectionDialog]![ReptEnd]
The expression evaluates correctly on the first page of the report (the first Referral Source section) but displays "#Error" on all subsequent pages.
Any ideas? This is really driving me crazy!
FranD
