I have a MS Access 2003 database application I'm writing. I have several forms with a series of controls on them. The controls are in basically two categories, an answer category displayed as comboboxes, and a score category displayed as text boxes.
The way that the form works, is the end-user selects an answer an it updates the corresponding score text box. I can accomplish this by manually typing in each name of each control, however, to be more effecient, I'd like to use a common procedure that is called by each combobox event. The names are like QUESTIONAnswer and QUESTIONScore. I can get the name of the combobox by using the me.activecontrol.name method. I have even figured out how to use the replace function to store the QUESTIONScore name in a variable.
Now to my problem, my thought was to use VARIABLE.Value = 0, however that doesn't work. I am wanting VBA to interpret VARIABLE.Value = 0 as QUESTIONScore.Value = 0 at runtime.
Is this even possible? Thank you in advance for any assistance!
The way that the form works, is the end-user selects an answer an it updates the corresponding score text box. I can accomplish this by manually typing in each name of each control, however, to be more effecient, I'd like to use a common procedure that is called by each combobox event. The names are like QUESTIONAnswer and QUESTIONScore. I can get the name of the combobox by using the me.activecontrol.name method. I have even figured out how to use the replace function to store the QUESTIONScore name in a variable.
Now to my problem, my thought was to use VARIABLE.Value = 0, however that doesn't work. I am wanting VBA to interpret VARIABLE.Value = 0 as QUESTIONScore.Value = 0 at runtime.
Is this even possible? Thank you in advance for any assistance!
