Hello,
I am using MS Access 2003 and trying to set a textbox's ControlSource in VBA code.
this following works fine
Task.ControlSou rce = "[ActivityQuery_C rosstab].[Task]"
However, if i try to set the control source using an expression like:
txtCost.Control Source = "[ActivityQuery_C rosstab]![Total] * [ActivityQuery_C rosstab]![CostOut]
or
txtCost.Control Source = "[Total] * [CostOut]"
Access tells me it cannot find the Field.
Am I issing something in the formatting here, I have tried using Expression Builder in a Query and then copy and pasting but no good.
Any ideas please?
regards,
Nick
I am using MS Access 2003 and trying to set a textbox's ControlSource in VBA code.
this following works fine
Task.ControlSou rce = "[ActivityQuery_C rosstab].[Task]"
However, if i try to set the control source using an expression like:
txtCost.Control Source = "[ActivityQuery_C rosstab]![Total] * [ActivityQuery_C rosstab]![CostOut]
or
txtCost.Control Source = "[Total] * [CostOut]"
Access tells me it cannot find the Field.
Am I issing something in the formatting here, I have tried using Expression Builder in a Query and then copy and pasting but no good.
Any ideas please?
regards,
Nick
Comment