User Profile

Collapse

Profile Sidebar

Collapse
Nick AU
Nick AU
Last Activity: Feb 9 '10, 11:17 PM
Joined: Feb 9 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Nick AU
    replied to Setting ControlSource in VBA
    in Access
    Many thanks, a simple solution that has saved the rest of my hair!

    Nick
    See more | Go to post

      Leave a comment:

    • Nick AU
      started a topic Setting ControlSource in VBA
      in Access

      Setting ControlSource in VBA

      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]

      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...