VBA Syntax for ControlSource

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
 
J

Judy

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?
 
D

Douglas J. Steele

Sorry, I don't have any suggestions. It worked fine for me when I tested
before posting.
 
Top