display text on report from form

[paritosh_a]

Can anybody tell me this:

i want one textbox on form to be entered by user.When this form is submitted, enteredf text on form must be displayed in report.
How can i do this ?

 

[pbaldy]

=Forms!FormName.ControlName

 

[paritosh_a]

Textbox showing error

Actually i m creating one textbox on a form.User enters some text into this textbox and clicks the button to open the report.
When the report is opened, there is a textbox which is showing this error: #Name?.

I set the textbox properties on report like this : forms!subfrminvoice.text29.
subfrminvoice is the form name and text29 is the textbox on form.

 

[pbaldy]

First make sure the form is still open when the report runs (and that there's an "=" at the start of that control source). Second, the name of the form implies it may be a subform, in which case the reference is wrong. Here's a good reference if it's a subform:

http://www.mvps.org/access/forms/frm0031.htm

 

[paritosh_a]

Thanks its working now

Its working