i need to assign variables from a recordset called from an SQL statement but i can't figure out how to change the Field Name bit to a variable .... i've tried all sorts of bracket combinations, etc but to no avail. is this possible at all?

EG:

VarToBeAssigned = RstRecordSet![NeedToHaveVarInHere]