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