views:

252

answers:

1

How can I write the control source into VBA instead of in the properties window

For example if I have a textbox that divides two amounts in other text boxes, then i put

=[textboxA]/[textboxB]

in the control source of the properties window. how do i accomplish this in vb so that I can trigger it by events?? i know it is not the same because I already tried that.

+1  A: 

That depends on what exactly you want to do. If you want to put the current value of textboxA / textboxB into textboxC, use:

Me!textboxC.Value = Me!textboxA.Value / Me!textboxB.Value

On the other hand, if you want to set the control source property so that the value is updated automatically, use:

Me!textboxC.ControlSource = "=[textboxA]/[textboxB]"

(Code untested, I don't have Access available right now.)

Heinzi
thanks very much!
Justin
The .Value property is redundant, as it's the default property of an Access control.
David-W-Fenton