Access - Tabbed Form - VB to use a Variable within code to send value from one tab's Subform to another Tab's Subform
Posted on 2012-12-27
Need some clarification. I asked earlier today how to change a code to make a subform name variable so that I could copy multiple pieces of data to multiple subforms (I am making the last two characters of my controls and textboxes numeric sequences so I can get a way to do/for loops)
Now then my data is coming from a Subform on Page1 of my Tabbed Form.
And is going to Other Tabs Subforms of that same Tabbed Form.
Earlier Mbiz pointed out using Me.Controls("xxxx" & i) as a way to accomplish that. However once I moved my form to a Tabbed and split my form up into several Subforms on different tabs, that coding scheme didn't work.
I attempted changing it several ways but it did not like starting with me.controls
Any idea how I could make that coding variable so that the forms and textboxes with the last characters as 1,2,3,4....could be converted to something like
Me("form" & i).("textbox" & format(i,"00")