VBA Syntax for ControlSource

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I'm trying to set the ControlSource for an unbound control on a report
and I'm having trouble with the syntax. If I use

Me.Budget.ControlSource = "Budget"

this works, but what I actually want is to add 2 numbers together,

Me.Budget.ControlSource= Budget1 + Budget2

I have tried many variations with brackets, quotes, and parenthesis,
but I can;t quite get it.

Thanks
 
Thank you for your reply. When I do this, my data is not right. All
the data is the same for every line within the group (the first line's
Budget1). This does not happen with just "Budget1" in the control
source. Any ideas where I went wrong?
 
Sorry, I don't have any suggestions. It worked fine for me when I tested
before posting.
 
Back
Top