Using Variables to Refer to Form Objects
Windows 7 32bit 
Access 2007
Hello and thank you for taking the time to read my question.
In its simplest, is it possible to use variables to refer to text boxes on a form? Essentially, I have X text boxes named something like TextBox1, TextBox2,...TextBoxX. I want to save the value of Y textboxes (Y < X) to a table but Y comes from the user. I had imagined using a do loop for i = 1 to X and the problem I'm running into is referring to the text boxes in a line like the following:
.fields("Field") = me.("TextBox" & i)
Is this even possible? If not, are there any suggestions? Thank you very much.
Reply With Quote
