[AccessD] Fieldnames in a Recordset

Hi Everyone

If someone could please help me here I'd be extremely grateful.

I have a string which is a field name - ie str = "fieldname"
Then I open a recordset and want to retrieve the value of that field from
the recordset, but want to pass the name as the str, not use the
rst!fieldname=.  I'm doing this because I'm looping through 30 odd fields
and don't want to have to type each one out, rather loop through the
controls and get the names this way.  Hope this makes sense.

Cheers

Selina