[AccessD] Setting field name in recordset

Language may be a reserved word.   Maybe use strLanguage or strLang?

The syntax looks correct

Perry Harold 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, May 23, 2006 4:59 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Setting field name in recordset

      ctl.Caption = rstControls.Fields(language)
 
I'm trying to grab a value from a recordset where the field changes. The
variable language is a string that holds the field name and I don't know
whether that's the problem or whether I'm using the wrong syntax. Should
I be referring to a field object instead of a string? I'm sure I've done
this before, but I just can't remember how. 
 
I'm using ADO, not DAO. 
 
Susan H. 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com