>Am working on unbound dbgrid coding and want to be able to retrieve
>a certain value from a field in a recordset.
>
>I get the name of the field I want to find with :
>
>fieldName = RS.Fields(Count).Name
>
>but when it comes to retrieving the value out of this field
>like I would do normally i.e:
>
>descr = RS!Description
>
>I want instead to retrieve using the 'fieldName' value
>
>i.e
>
>descr = RS!fieldName <--- variable instead of hardwired db field
> name.
>
>I just cant seem to get the syntax right and have look everywhere for an example but no banana.
>
>Any one got the answer to this one?
>
>
>Thanks in Advance
>
>Frixos
Use this syntax:
desc = RS(variable)