Get Field value from adorecordset?

[Meeko]

Dear all,
I know that we can use the following codes to get the field value of name user "adoRecordset!",

Dim adoRecordset As ADODB.Recordset
adoRecordset!name

but what if "name" is not the field name itself but is a variable holding the field name?

what is the correct syntax?

Thanks
Meeko