Displaying Date on every Report Page

[becky250]

I have set up a database that analyses the effectiveness of production lines.
For my report, users select a Start Date and End date (through a form) and
the enter button brings up the report. The first page (first production line)
displays the start and end date however any other page (the other production
lines that were on the same days) is displaying "#Name?". How can i solve
this so the date range is displayed on every page?

Regards

Rebecca

 

[Allen Browne]

If the Control Source of the text box on the report looks like this:
=[Forms].[Form1].[StartDate]
then make sure the form stays open in the background while the report is
open.

 

[Allen Browne]

Sounds like something has confused it here.

Perhaps Name AutoCorrect. Perhaps the name of the field/control is a
reserved word. Perhaps there's a conflict with another name. Perhaps there's
some calculation in there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I tried (on a backup file!) to remove the 'close form on click' part of the
'ok' button in Visual Basic but now when the report comes up, the first
date
is correct but the other pages display a completely random, incorrect
date.

If the Control Source of the text box on the report looks like this:
=[Forms].[Form1].[StartDate]
then make sure the form stays open in the background while the report is
open.

I have set up a database that analyses the effectiveness of production
lines.
For my report, users select a Start Date and End date (through a form)
and
the enter button brings up the report. The first page (first production
line)
displays the start and end date however any other page (the other
production
lines that were on the same days) is displaying "#Name?". How can i
solve
this so the date range is displayed on every page?

Regards

Rebecca