Report help

[blake7]

Hi All, I have created a report that is linked to a query, the query criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks

 

[Al Campagna]

blake7,
I'm not sure, but try the exclamation "!" instead of period the "."
I've used the same many times.
Make sure the form stays open...

=[Forms]![weekly summary date select]![startdate]
=[Forms]![weekly summary date select]![enddate]

--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks

 

[Gina Whipp]

blake7,

Do you close the form at any point?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[blake7]

HI, thanks for replying, It does not make a difference if I close the form or
leave it open, I cannot get the text boxes to show the dates on the other
pages of the report.

blake7,

Do you close the form at any point?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks

.

 

[blake7]

Hi Al, tried the exclamation mark, it makes no difference?

blake7,
I'm not sure, but try the exclamation "!" instead of period the "."
I've used the same many times.
Make sure the form stays open...

=[Forms]![weekly summary date select]![startdate]
=[Forms]![weekly summary date select]![enddate]

--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks

.

 

[blake7]

Hi Gina, i owe you an appology, I was closing the form too early and the
dates do show if i don't
thanks for your help

blake7,

Do you close the form at any point?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks

.

 

[Gina Whipp]

blake7,

If you close the form it will never work. Is the form visible? I have a
report that pulls it's dates from a from and have never had this problem and
yes, the report is multiple pages.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

HI, thanks for replying, It does not make a difference if I close the form
or
leave it open, I cannot get the text boxes to show the dates on the other
pages of the report.

blake7,

Do you close the form at any point?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between"
statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear?
Thanks

.

 

[Gina Whipp]

No problem... just glad we got that solved. As a suggestion, try making the
form Visible False and see if that causes the same issue. That way your
form can remain open but out of sight. Providing that works, don't forget
to close the form when the report closes.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina, i owe you an appology, I was closing the form too early and the
dates do show if i don't
thanks for your help

blake7,

Do you close the form at any point?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between"
statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear?
Thanks

.

 

[Al Campagna]

As I said in my first post...The form must remain open if you are going to reference the
value/s of a control on that form.
So... while we shoot this bug, leave it open.
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

HI, thanks for replying, It does not make a difference if I close the form
or
leave it open, I cannot get the text boxes to show the dates on the other
pages of the report.

blake7,

Do you close the form at any point?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between"
statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear?
Thanks

.