Good evening all...



Quick question...  Is it possible to use a variable when calling out to

an Access DB to retrieve information or more specifically update

information?



As an example:



Traditional method:  



rsConfig("test") = "Test Data"

rsConfig.Update



What I would like to do:  



Field = "test"

rsConfig(Field) = "Test Data"

rsConfig.Update



Here "test" would be a field within the rsConfig RecordSet.  I would

like to be able to assign "test" to variable as opposed to hard coding

it into the application and be able to write new information to the DB

in the Test field.  I have been unable to accomplish this task as I keep

getting the error:



ADODB.Recordset error '800a0cc1'



Item cannot be found in the collection corresponding to the requested

name or ordinal.





I am stumped... any help would be appreciated.



Regards,

Eric Levine