[AccessD] Value of a recordset field

Sorry... "rs(strFieldname).value" DID work..... I just had a different
problem!......Barb

----- Original Message ----- 
From: "Barbara Ryan" <BarbaraRyan at cox.net>
To: "Access List" <AccessD at databaseadvisors.com>
Sent: Friday, March 19, 2004 12:02 PM
Subject: [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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com