I have a table with the following fields: Name, text1, text2, text3.

In the following code example (Which does not work) i am trying to figure out a way to reference a recordset field using an integer. I can not reference rc!texti. Is there a way to use the value of i so that rc!text + the i will be allowed in code?????? The reason I need to do this is in the live data I have Text1 thru Text34.

*****************************
Dim db as database
Dim rc as recordset
Dim strSQL as string
Dim i as integer

for i = 1 to 3

strSQL = "Select * from Table where Text" & i & " not null;"
Set DB...
Set RC...

rc!texti = "Hi There"

next i