mainrotor
asked on
Is there a way to dynamically change the column captions on an ACCESS 2010 subform
Hi Experts,
Is there a way to dynamically change the column captions on an ACCESS 2010 subform.
Thank you very much in advance,
mrotor
Is there a way to dynamically change the column captions on an ACCESS 2010 subform.
Thank you very much in advance,
mrotor
Is your subform a form, or is the SourceObject of the subform control actually a query?
Is the form in datasheet view, perchance/
ASKER
Dale Fye,
The SourceObject of the subform is actually a query. Here's a sample of the code:
Thanks,
mrotor
The SourceObject of the subform is actually a query. Here's a sample of the code:
Dim pSQL As String
pSQL = "SELECT * FROM Staging_Table ORDER BY Staging_Table.Tech_Name"
Me.dataAvailabilitySubform.SourceObject = "Query.qryStagingTable"
Me.dataAvailabilitySubform.Form.RecordSource = pSQL
Me.dataAvailabilitySubform.Requery
Thanks,
mrotor
ASKER
If the control does not have an associated label:
Create a label.
Mark the label and press Ctrl+X
Mark the column and press Ctrl+V
Then:
https://www.experts-exchange.com/questions/28650357/Is-there-a-way-to-dynamically-change-the-column-captions-on-an-ACCESS-2010-subform.html?anchorAnswerId=40707497#a40707497
/gustav
Create a label.
Mark the label and press Ctrl+X
Mark the column and press Ctrl+V
Then:
https://www.experts-exchange.com/questions/28650357/Is-there-a-way-to-dynamically-change-the-column-captions-on-an-ACCESS-2010-subform.html?anchorAnswerId=40707497#a40707497
/gustav
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Me!SubformControlName.Form
/gustav