Good morning!
I have a form with several sets of text box/combo box pairings. My hope is to have control buttons that will call a function that will perform operations on a specific text/combo pair, depending on which button is clicked.
Essentially, I click a button, pass the combo box and text box names to global variables, then call the function which uses those varibles to know which pair of controls to use.
The problem I'm running into is how to add the variable into the VBA. Is there a way I can write
[Forms]![FormName].[ControlName]=?????
as
[Forms]![FormName].<GlobalVariable>=?????
Where the control is identified by the global variable?
I have a form with several sets of text box/combo box pairings. My hope is to have control buttons that will call a function that will perform operations on a specific text/combo pair, depending on which button is clicked.
Essentially, I click a button, pass the combo box and text box names to global variables, then call the function which uses those varibles to know which pair of controls to use.
The problem I'm running into is how to add the variable into the VBA. Is there a way I can write
[Forms]![FormName].[ControlName]=?????
as
[Forms]![FormName].<GlobalVariable>=?????
Where the control is identified by the global variable?
