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.
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.)