Can I have form input text into a report? and how?

B

Bevo12

I want to be able to add text to a report when it is entered into a form.
Can this be done? and if it can how?
 
T

Tom Lake

Bevo12 said:
I want to be able to add text to a report when it is entered into a form.
Can this be done? and if it can how?
Click to expand...

If the form will still be open when the report prints, create
a textbox on the report with the source being:

=[MyForm]![MyTextbox]

where MyForm is the name of the form and MyTextbox
is the name of the control on the form where you typed the
data.

Tom Lake
 
F

fredg

I want to be able to add text to a report when it is entered into a form.
Can this be done? and if it can how?
Click to expand...

If the form will be open when the report is run, you can add an
unbound control to the report.
Set it's control source to:
=Forms!FormName!ControlName

You can also have the report itself prompt for the added text if the
form will not be open.
Set the control source of the unbound control to:
=[What do you want to say?]
 
Top