Here's what I need help with....



Let's say I have Form1 with the following fields:
txt1, txt2, txt3, txt4

I have Form2 where someone is going to enter info into some combo boxes and click a button to transfer the information over to Form1. Rather than specifically calling txt1, txt2, etc I want to use a loop that sequentially goes though them. The reason being is first my function is going to check to see which is the 1st empty text box before entering data. So txt1 may already have a value so we need to start with txt2. I can code it to get to the proper text box but can't get it ot pass the values so I need something that essentially does this....(this is very generic since I need only this specific piece)

Counter ' variable that tells me which txt box number is empty

Do While Counter < 5
Forms!Form1!("txt" & Counter) = "xxxxxx"
Counter = Counter + 1
Loop

I would appreciate any help that I can get. Currently I either get an error that I can't assign a value to that field or I get no error but the txt boxes on Form1 show #Name?