[AccessD] Value of a recordset field

In an Access 97 app, I have a DAO recordset ("rs") which contains all of the fields in my Employee table ("tblEmp").

I need to retrieve the VALUE of the fieldname (not the field's name) contained in variable strFieldName.  strFieldname can be one of several values ("rs!EmpNo", "rs!BadgeNo", "rs!SSN", etc.) .  

How can I do this?  I've tried "rs(strFieldname).value", and variations of this, but can't get it to work

Thanks,
Barb