Someone please help, I am trying to use a variable to open fields in a recordset, ie.

Dim dbs As DATABASE, rst As Recordset, strSQL As String, strFieldName as string, strWhatever as string

strFieldName = "SomeField"

Set dbs = CurrentDb
strSQL = "SELECT * FROM ATABLE"
Set rst = dbs.OpenRecordset(strSQL)

strWhatever = rst!strFieldName

I've tried all manner of ways to get this to work but it just won't replace the strFieldName with the variable value, it keeps looking for that as the field.

There's probably a better way of going about it, I just can't see it  

Try:

rst.Fields(strFieldname)

That worked a treat, thanks a lot.

using variable use fieldname
Dim dbs As DATABASE, rst As Recordset, strSQL As String, strFieldName as string, strWhatever as string

Set dbs = CurrentDb
strSQL = "SELECT * FROM ATABLE"
Set rst = dbs.OpenRecordset(strSQL)

strWhatever = rst!name