Form field in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Smiffy said:
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]
Click to expand...

Sounds like the form is being closed. It must remain open
until the report is closed.
 
Thanks Marsh, i'll check it out

Marshall Barton said:
Smiffy said:
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]
Click to expand...

Sounds like the form is being closed. It must remain open
until the report is closed.
Click to expand...
 
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

Marshall Barton said:
Smiffy said:
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]
Click to expand...

Sounds like the form is being closed. It must remain open
until the report is closed.
Click to expand...
 
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 said:
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]
Click to expand...
Click to expand...

Marshall Barton said:
Sounds like the form is being closed. It must remain open
until the report is closed.
Click to expand...
Click to expand...
 
Thanks for the reply Marshall, hope you had a good vacation.


Marshall Barton said:
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]
Click to expand...

Marshall Barton said:
Sounds like the form is being closed. It must remain open
until the report is closed.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top