text boxes

[DJACKSON]

I have a unbound text box on a form that's not in a query how do i bind that
to a report?

 

[Klatuu]

Can't be done.
Tell use what you want to do and perhaps we can tell you how.

 

[DJACKSON]

I have a label sticker report based on a select query and I would like to add
text to the sticker. The add text would change constantly so I would like to
enter that on a form through a text box. Is there any hope? Thanks for your
help

 

[Douglas J. Steele]

If all you're trying to do is copy text from the form onto the report, try
setting the ControlSource on the report to

=Forms![NameOfForm]![NameOfUnboundControl]

(complete with equal sign)

Note that the report won't work properly if the form isn't opened first.

 

[fredg]

I have a label sticker report based on a select query and I would like to add
text to the sticker. The add text would change constantly so I would like to
enter that on a form through a text box. Is there any hope? Thanks for your
help

It's still not clear (at least to me) exactly what you are attempting
to do with the value in the form's text box, but:
You could refer to the form control from the report, i.e.

=Forms!FormName!ControlName

The Form must be open when the report is run.

 

[Klatuu]

If you are on version 2003, you can use the OpenArgs argument of the
OpenReport method to pass the value of the text box to the report; otherwise,
you will have to do it from the Open event of the report.

If using the OpenArgs, you still use the Open event of the report.

If Not IsNull(Me.OpenArgs) Then
Me.lblMessage = Me.OpenArgs
End If

If you do it from the report

Me.lblMessage = Forms!MyFormName!MyTextBoxName