Addressing fields in table

[NWTrust]

Hi
I want to reset the contents of all instances of a field in a table. I have in mind (all necessary dims taken care of):

Set db=CurrentDB
Set rst=db.OpenRecordset("tblPrinters")
For i=1 to rst.RecordCount
[insert fixed text into required field]
Next i

How do I address the required field to insert this text?

Any help would be appreciated

NWTrust

 

[MajP]

dim strSql as string
strSql = "UPDATE tblName SET fieldName = 'someString'"
currentdb.execute strSql

 

[NWTrust]

Thanks, MajP. It did the trick.

NWTrust