How to mention field names along with variables

[pardhu81]

Dear All, I have textbox's where i renamed as TN1 , TN2, TN3, TN4 etc..


I want to use these field names in vba. and i want to put in a loop these fields and update accordingly.
while doing that i am looking for an syntax which looks something like below...

Dim i as integer

ME.TN & i = rst![FIELD]
i = i + 1

In above example i value increments in loop and updates the values which is available in recordset.
Obviously above syntax thrown error. can you suggest me the right syntax..

Thanks in Advance.

[jwhite]

Don't know what rst![Field] is about but the other part:

For i = 1 to 10
Me.Controls("TN" & CStr(i)) = rst![Field]
Next

[pardhu81]

Wonderful.
Now another issue..
I have this text field in Tab Control.
When i try to update it is throwing error saying.. "You Cant Assign a Value to this Object".

How to handle text field which is placed on Tab Control?