Page Header Problem

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

Guest

I have a text box currently in my report header that I want to display the
record selected in a combo box on a another form. the control source for my
text box is:
[Forms]![frmRunReports]![cboResponseChoice].
It works fine in the report header, but I want it to print on every page of
the report.

But, when I move it to the page header, I get the following error:
"Microsoft Access can't find the field
'[Forms]![frmRunReports]![cboResponseChoice]' referred to in your expression.
You may have misspelled the field name, or the field may have been deleted or
renamed."

Any idea why this is happening or how to fix it? Thanks!

Wendy
 
The expression should be okay in a text box in the Page Header,
provided:
a) the form remains open in the background, and
b) you include the = at the start of the control source
 
Thank you!!

Apparently, I was missing the "=". Out of curiousity, why did I need the "="
when the expression is in the Page Header, but not for the Report Header? I
double checked, and the expression did work without "=" in the Report Header.

Allen Browne said:
The expression should be okay in a text box in the Page Header,
provided:
a) the form remains open in the background, and
b) you include the = at the start of the control source

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

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

Wendy said:
I have a text box currently in my report header that I want to display the
record selected in a combo box on a another form. the control source for
my
text box is:
[Forms]![frmRunReports]![cboResponseChoice].
It works fine in the report header, but I want it to print on every page
of
the report.

But, when I move it to the page header, I get the following error:
"Microsoft Access can't find the field
'[Forms]![frmRunReports]![cboResponseChoice]' referred to in your
expression.
You may have misspelled the field name, or the field may have been deleted
or
renamed."

Any idea why this is happening or how to fix it? Thanks!

Wendy
Click to expand...
Click to expand...
 
Wendy said:
I have a text box currently in my report header that I want to display the
record selected in a combo box on a another form. the control source for my
text box is:
[Forms]![frmRunReports]![cboResponseChoice].
It works fine in the report header, but I want it to print on every page of
the report.

But, when I move it to the page header, I get the following error:
"Microsoft Access can't find the field
'[Forms]![frmRunReports]![cboResponseChoice]' referred to in your expression.
You may have misspelled the field name, or the field may have been deleted or
renamed."

Any idea why this is happening or how to fix it? Thanks!

Wendy
Click to expand...
..
 
Indeed: why does it work in the Report Header?

Any expression should start with "=", so why the incorrect entry works in
the Report Header is beyond me.

Sometimes Access tries to be too clever. I do not believe that these
inconsistencies are helpful.

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

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

Wendy said:
Thank you!!

Apparently, I was missing the "=". Out of curiousity, why did I need the
"="
when the expression is in the Page Header, but not for the Report Header?
I
double checked, and the expression did work without "=" in the Report
Header.

Allen Browne said:
The expression should be okay in a text box in the Page Header,
provided:
a) the form remains open in the background, and
b) you include the = at the start of the control source


Wendy said:
I have a text box currently in my report header that I want to display
the
record selected in a combo box on a another form. the control source
for
my
text box is:
[Forms]![frmRunReports]![cboResponseChoice].
It works fine in the report header, but I want it to print on every
page
of
the report.

But, when I move it to the page header, I get the following error:
"Microsoft Access can't find the field
'[Forms]![frmRunReports]![cboResponseChoice]' referred to in your
expression.
You may have misspelled the field name, or the field may have been
deleted
or
renamed."

Any idea why this is happening or how to fix it? Thanks!

Wendy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top