Dynamically set field in recordset

[drgsolutions]

I am attempting to dynamically set the field I wish to update at run time.

This is my code (DAO)

rs.Edit
rs(parameter)
rs.Update

I have tried using [] () ! and . characters to now avail. Anyone know how to pass a string character into a recordset object and have it recognized as a field name?

Thanks a bunch

 

[PWise]

rs.Edit
rs([COLOR=red][b]"Fieldname"[/b][/color])
rs.Update

 

[LARiot]

I'm not sure what's meant by dynamically setting the field or what you're trying to do here exactly.

Specifically, what're you trying to do?

This may be some of what you're looking for:

rs.Fields("Field Name")

-Neema

 

[LARiot]

Actually, sorry. What pwise has is correct. rs.Fields("Field Name") is for referencing an excel sheet.

-Neema