call textfield (not from table) from the report designer!

  • Thread starter Thread starter Sam Hung
  • Start date Start date
S

Sam Hung

Hi All,

I'm now having little troubles about to call textfield
data into the report designer. I have a form
called "form1" and table "table123" with 3 fields set
(t1, t2, t3), and had just created a new textfield -
"text1" (no control source - means not from
table/database). Now in the properties of control source
I wrote [forms]![form1]![text1]. It doesn't work, why?

Is there any other way out or I should stay in these
little problems.

Please help, thks.
 
try it without the brackets:

text1 =Forms!Form1![Text1]
Where text1 is the unbound field on your report and
Text1 is the bound textbox on Form1.

You might want to use more descriptive names to avoid
confusion.
*Also note: I believe that the form must be open at the
time the report is called or you may receive an error.

See the MVPs advise on naming conventions

www.mvps.org/access
 
Hi,

Thanks for your help. I tried it last night. This is
exactly what my problem is. I received an error message
under that field. The form and report must be open at the
same time as you are writing a system. So would you have
any good idea or something I should do to avoid this
problem?

Urgent,
Thanks,
Sam.
-----Original Message-----
try it without the brackets:

text1 =Forms!Form1![Text1]
Where text1 is the unbound field on your report and
Text1 is the bound textbox on Form1.

You might want to use more descriptive names to avoid
confusion.
*Also note: I believe that the form must be open at the
time the report is called or you may receive an error.

See the MVPs advise on naming conventions

www.mvps.org/access

-----Original Message-----
Hi All,

I'm now having little troubles about to call textfield
data into the report designer. I have a form
called "form1" and table "table123" with 3 fields set
(t1, t2, t3), and had just created a new textfield -
"text1" (no control source - means not from
table/database). Now in the properties of control source
I wrote [forms]![form1]![text1]. It doesn't work, why?

Is there any other way out or I should stay in these
little problems.

Please help, thks.
.
Click to expand...
.
Click to expand...
 
Back
Top