I have a situation using this kind of code in a routine:

iValue = dbRecordset![Field1]

(bang notation using ADO recordset)

Thing is, I want to assign the data field to a variable, and then use the variable in the code, something like this:

Dim sDataField as String
sDataField = "[Field1]"

iValue = dbRecordset! & sDataField

--Of course, this doesn't work! I don't know the proper way to set this up. I would be grateful for any suggestions on how to do this.

Thanks,
PSW