So here is what i have. I have a section of list boxes labeled txtcard0 through txtcard19. Instead of having to do the same line over and over to assign a new variable to each listbox, is there a way to increment the number at the end? I've tried using & and assigning a counter variable and incrementing but neither works. Heres what I have:
db1.Form_PriceForm.txtCard0.value = "test"
db1.Form_PriceForm.txtCard1.value = "test"
db1.Form_PriceForm.txtCard2.value = "test"
db1.Form_PriceForm.txtCard3.value = "test"
db1.Form_PriceForm.txtCard4.value = "test"
db1.Form_PriceForm.txtCard5.value = "test"
..............................
Is there a way to do something like
Dim Counter
Counter = 0
db1.Form_PriceForm.txtCard & Counter.value = "test"
Counter +1
?? If its not possible then no big deal.