Using variable to reference table field for updating

[elliotgr]

I have a variable that must determine what field must be populated in a table. Is this possible?

Sub Get_Variable_Field_Name()
 
dim db as database
dim rst as recordset
 
set db = Currentdb
set rst = OpenRecordset("MyRecordSet")
 
VarFieldName = "Valid table field name goes here"
 
rst.addnew
rst!("How do I reference the varable as a field name") = "MyFieldValue"
rst.update
 
rst.close
db.close
set rst = nothing
set db = nothing
end sub

 

[vbaInet]

rst.Fields(variable) = "something"

 

[elliotgr]

Thanks, but sorry, no joy when trying to update the field.

This works

rst!MESSAGE = "Hello"

but this does not

dim strField as string
strField = "MESSAGE"
rst!Fields(strField) = "Hello"

I get error 3265, item not found in this collection.

 

[vbaInet]

Please re-read my post and follow the exact syntax.

 

[elliotgr]

My mistake, typing error, but had a data conversion error throwing me off track. (Field variable was a date, so I had to force it to as string). Once that was fixed, all works fine

 

[vbaInet]

Good job elliotgr!