[AccessD] Fieldnames in a Recordset

Drew Wutka DWUTKA at marlow.com
Wed Mar 26 22:15:37 CST 2003


rs.field(strName).value

Drew 

-----Original Message-----
From: Selina Iddon
To: accessd at databaseadvisors.com
Sent: 3/26/03 8:07 PM
Subject: Re: [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list