Report Info Coming From Query & Form?

  • Thread starter Thread starter CEVisker
  • Start date Start date
C

CEVisker

I want to build a report that takes info from a current query that
already have, but then to also add specific info that I type in eac
time in an unbound text box in a form. After I enter this info in th
form, I have a buttom to open the Report. Is this possible? How can
do it?

Am I somehow able to add these textboxes into my query although the
are not from any table?

Would I add "Like [Forms]![Name of form]![txtbox name]" into a ne
colum in the query? Would I add this into the Criteria row and leav
the Field and Table rows blank?

Thanks,

Cha
 
Chad,

It can work directly off the form perfectly well, no ineed to include it in
the query. Assuming your form's name is MyInputForm and the textbox control
is called MyComment: in your report desing, make a new textbox control and
set its controlsource property to:
Forms!MyInputForm!MyComment
(change the names to the actual ones). As long as the form is open when you
run the report, the comment will be picked up.

HTH,
Nikos
 
Back
Top