how do you unbound text from form to report

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

Guest

I have an unbound text field on a form, for a persons name...
Supervisors will fill in the form, then press a button to email a copy to
our front office...
I know you can't email a form, so I set up a report that looks similar to
the form and I have all the functionality figured out except for this one
unbound text box...
I can't for the life of me get the info in this text box to any type of
field (text box, label, etc.) on the report...any help is greatly appreciated.
 
Joe,

If the form is remaining open when you call the report, you
can refer to the unbound control on the form directly from
the report. Using your names, use this method on the report
to grab the form info and display in a textbox control on
the report. Place this in the ControlSource of the textbox.

=Forms!YourFormName!YourControlName

You can use this syntax to grab it from a lot of different
places including VBA code.
 
Thanks Gary,
After I posted, I went right back to working on it, I removed the old
controls, added new ones, didn't change the overall process and I used the
ControlSource this time instead of the VBA Code I was trying and it worked,
thanks for the input.
 
I have an unbound text field on a form, for a persons name...
Supervisors will fill in the form, then press a button to email a copy to
our front office...
I know you can't email a form, so I set up a report that looks similar to
the form and I have all the functionality figured out except for this one
unbound text box...
I can't for the life of me get the info in this text box to any type of
field (text box, label, etc.) on the report...any help is greatly appreciated.
Click to expand...

Try

=[Forms]![NameOfTheForm]![NameOfTheTextbox]

in the Control Source of a report textbox. The form must be open for
this to work.

John W. Vinson[MVP]
 
Back
Top