D
DJACKSON
I have a unbound text box on a form that's not in a query how do i bind that
to a report?
to a report?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Klatuu
Can't be done.
Tell use what you want to do and perhaps we can tell you how.
Tell use what you want to do and perhaps we can tell you how.
D
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
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
D
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.
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.
F
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.
K
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
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