Because:
field = "xxx"
value = "zzz"
replace &field with value
works by me, i think you must replace:
lcfieldname = "field" + INT(VAL(lnCnt))
with:
lcfieldname = "field" + alltrim(str(INT(VAL(lnCnt))))
Also, make sure "fieldX" is character field.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...
