[AccessD] Setting field name in recordset

Susan

Isn't it rstControls(language)?

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Susan Harkins
> Sent: 23 May 2006 21:59
> 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
>