If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
text boxes
I have a unbound text box on a form that's not in a query how do i bind that
to a report? |
#2
|
|||
|
|||
text boxes
Can't be done.
Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: I have a unbound text box on a form that's not in a query how do i bind that to a report? |
#3
|
|||
|
|||
text boxes
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 "Klatuu" wrote: Can't be done. Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: I have a unbound text box on a form that's not in a query how do i bind that to a report? |
#4
|
|||
|
|||
text boxes
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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "DJACKSON" wrote in message ... 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 "Klatuu" wrote: Can't be done. Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: I have a unbound text box on a form that's not in a query how do i bind that to a report? |
#5
|
|||
|
|||
text boxes
On Wed, 9 Jan 2008 08:28:01 -0800, DJACKSON wrote:
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 "Klatuu" wrote: Can't be done. Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: I have a unbound text box on a form that's not in a query how do i bind that to a report? 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. -- -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#6
|
|||
|
|||
text boxes
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 -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: 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 "Klatuu" wrote: Can't be done. Tell use what you want to do and perhaps we can tell you how. -- Dave Hargis, Microsoft Access MVP "DJACKSON" wrote: I have a unbound text box on a form that's not in a query how do i bind that to a report? |
Thread Tools | |
Display Modes | |
|
|