dereference a string

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?

Try inserting the first recordset field into the second instead of
using a variable.

VB Code:

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

i tried that and it doesn't work

nevermind, i forgot to put the .Value at the end. It works now!!! thanks