dereference a string

[niner]

I am tring to run this code:
----------------------
Dim col_name As String

col_name = tmprs![Field1]
Sheet.cells(1, 1).Value = tmprs1![col_name]

----------------------

tmprs and tmprs1 are both recordsets, and it changes each time. When I try to access tmprs1![col_name], it literally looks for the column name "col_name" instead of what's stored inside of it. How can I dereference col_name?