I’m posting from my phone so I don’t have code on me at the moment, but here’s the situation. I have a form that contains two sub forms, two combo boxes, and a text box. Combo box A selects an application, which after update will populate sub form A with data (displayed in database view). Whatever value is in column A in sub form A will be sent to the text box as the control source. The text box is then used as the Master field for sub form B. (I hope this made sense, and if not I can get an image).
All of that works fine. I’m trying to introduce Combo Box B into the workflow, so that it acts as the text box control source when required. I’d like to utilize the same text box, as I need the data displayed in sub form B still.
How can I dynamically change the text box control source between SubFormA.ColumnA and ComboBoxB.Value?
All of that works fine. I’m trying to introduce Combo Box B into the workflow, so that it acts as the text box control source when required. I’d like to utilize the same text box, as I need the data displayed in sub form B still.
How can I dynamically change the text box control source between SubFormA.ColumnA and ComboBoxB.Value?