Use option button to change control source

papata123

New member
Local time
Yesterday, 18:46
Joined
Aug 6, 2007
Messages
4
I'm creating my first access database and I would like to use 3 option buttons, link them together so only one is selected at once, and use them to change the control source of a text box. I have a textbox on a form that I would like to display an estimate in. I have three different type of estimates in my table, so i'd like the form to display which ever estimate is selected. Hope this makes sense, and thanks for the help.

Ty
 
I was thinking that on the click event I could code something like: Forms!Project Details!Budget.ControlSource = "High Level Est" which would change the textbox Budget's control source to High level estimate. I don't really know much vba syntax, and this isn't working, so I'm not sure if this is in the right direction. Any help?
 

Users who are viewing this thread

Back
Top Bottom