Form field in a report

[Smiffy]

I have a report and i want to put a date in it that has previously been
entered in a form. It works for the first page but i just get #Name? on all
other pages.

my field on the rport is =[Forms]![PrintInvoiceStats1]![Invoice Start Date]

Any help would be appretiated

 

[Marshall Barton]

I have a report and i want to put a date in it that has previously been
entered in a form. It works for the first page but i just get #Name? on all
other pages.

my field on the rport is =[Forms]![PrintInvoiceStats1]![Invoice Start Date]

Sounds like the form is being closed. It must remain open
until the report is closed.

 

[Smiffy]

Thanks Marsh, i'll check it out

I have a report and i want to put a date in it that has previously been
entered in a form. It works for the first page but i just get #Name? on all
other pages.

my field on the rport is =[Forms]![PrintInvoiceStats1]![Invoice Start Date]

Sounds like the form is being closed. It must remain open
until the report is closed.

 

[Smiffy]

Hi Marsh,

That was the problem, I have setup a macro and opened the form, then opened
the report, then closed the form Why did it close the form before the end of
the report and how should i close it?

Brian

I have a report and i want to put a date in it that has previously been
entered in a form. It works for the first page but i just get #Name? on all
other pages.

my field on the rport is =[Forms]![PrintInvoiceStats1]![Invoice Start Date]

Sounds like the form is being closed. It must remain open
until the report is closed.

 

[Marshall Barton]

I just got back from vacation and hope you didn't think your
question was abandoned.

Reports run asynchronously from other parts of Access. You
can either open the report in Dialog mode (not generally
recommended, but ocassionally useful) or use some code (or a
macro) in the report's close event to close the form.
--
Marsh
MVP [MS Access]

That was the problem, I have setup a macro and opened the form, then opened
the report, then closed the form Why did it close the form before the end of
the report and how should i close it?

I have a report and i want to put a date in it that has previously been
entered in a form. It works for the first page but i just get #Name? on all
other pages.

my field on the rport is =[Forms]![PrintInvoiceStats1]![Invoice Start Date]

Sounds like the form is being closed. It must remain open
until the report is closed.

 

[Smiffy]

Thanks for the reply Marshall, hope you had a good vacation.

I just got back from vacation and hope you didn't think your
question was abandoned.

Reports run asynchronously from other parts of Access. You
can either open the report in Dialog mode (not generally
recommended, but ocassionally useful) or use some code (or a
macro) in the report's close event to close the form.
--
Marsh
MVP [MS Access]

That was the problem, I have setup a macro and opened the form, then opened
the report, then closed the form Why did it close the form before the end of
the report and how should i close it?

Smiffy wrote:
I have a report and i want to put a date in it that has previously been
entered in a form. It works for the first page but i just get #Name? on all
other pages.

my field on the rport is =[Forms]![PrintInvoiceStats1]![Invoice Start Date]

Sounds like the form is being closed. It must remain open
until the report is closed.