Return ADODB recordset value?

[MaximusArcher]

Say I have an ADODB recordset with two fields in it called 'FirstName' and 'LastName'.

I want to return the values into variables which is normally done as...

strValue1 = rst![FirstName]
strValue2 = rst![LastName]

However, what I want to do is assign the field to retrieve to a variable also and then use this variable to identify which field to query.

sort of like

strFieldName = "LastName"
strValue1 = rst![strFieldName]

is it possible, a better way?

thanks,
Matt.

 

[RuralGuy]

I think:
strFieldName = "LastName"
strValue1 = rst.fields(strFieldName)
should work.