Unbound form Iterate a recordset with loop changing the textbox name from text1 to text2 to display information vba code
Posted on 2006-05-17
I am using Access 2003.
I have an unbound form with a text boxes say text1 , text2, etc to text10 I need to iterate the recordset and change the recipient of the record each time from text1 to text2. So I need build the name from text on the first loop to text1 and so on. I can do this the long way but would like a neater way.
The reason I am using unbound is that there is a lot of data from many sources on the form and I would end up with lots of listboxes or sub -forms. Thanks