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
|
|||
|
|||
Label Caption on Subform from Textbox Value on Main Form
On sfmProducts I have Label1 that is associated with txtColumn1. On
frmProducts I have txtColumnCaption1. I would like to have sfmProducts display in datasheet view and have the caption of Label1 on the subform set to the value of txtColumnCaption1 on the main form. If I enter the following formula as the Caption of Label1 then the column heading in datasheet view displays the formula itself. =[Forms].[frmProducts]![txtColumnCaption1].[Value] If I enter the same formula for the Control Source of txtColumn1 then the value from the main form does indeed display. What am I doing wrong? |
#2
|
|||
|
|||
Label Caption on Subform from Textbox Value on Main Form
To use the expression =[Forms].[frmProducts]![txtColumnCaption1], change the
label to a textbox. Set its enabled property to No and its locked property to Yes. To use a label instead, write some code like: Me.Label1.Caption =[Forms].[frmProducts]![txtColumnCaption1] Where to put that code? Every time txtColumnCaption1 changes, the value of Label1 on the subform needs to change. What makes the value of txtColumnCaption1 change? You will find that you don't need to put .[Value] in the expression. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Steve P" wrote in message news On sfmProducts I have Label1 that is associated with txtColumn1. On frmProducts I have txtColumnCaption1. I would like to have sfmProducts display in datasheet view and have the caption of Label1 on the subform set to the value of txtColumnCaption1 on the main form. If I enter the following formula as the Caption of Label1 then the column heading in datasheet view displays the formula itself. =[Forms].[frmProducts]![txtColumnCaption1].[Value] If I enter the same formula for the Control Source of txtColumn1 then the value from the main form does indeed display. What am I doing wrong? |
#3
|
|||
|
|||
Label Caption on Subform from Textbox Value on Main Form
Hi Steve,
The thing you're doing wrong is using a label control. As you've found, it cannot evaluate an expression in its caption, where a textbox can evaluate an expression set as its ControlSource. Simply change the label to a textbox; you can set its propertyies to Enabled = No and Locked = Yes to prevent access to it, and when the form displays users will not know the difference. About the only thing you lose is the ability to link it to a textbox, so that they move together; but once you've designed your form, that's really irrelevant. HTH, Rob Steve P wrote: On sfmProducts I have Label1 that is associated with txtColumn1. On frmProducts I have txtColumnCaption1. I would like to have sfmProducts display in datasheet view and have the caption of Label1 on the subform set to the value of txtColumnCaption1 on the main form. If I enter the following formula as the Caption of Label1 then the column heading in datasheet view displays the formula itself. =[Forms].[frmProducts]![txtColumnCaption1].[Value] If I enter the same formula for the Control Source of txtColumn1 then the value from the main form does indeed display. What am I doing wrong? |
Thread Tools | |
Display Modes | |
|
|