[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.
> 

Use the rs("fieldname") structure ie rs(str)


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.