Passing the name of a field to a Recordset 1

[jbranero]

Hi, I am trying to access the name of a field in a Recordset but when I try the following:

SSField = LTable!Field_1

Where: SSField is a string; LTable a Variant (treated as Recorset) and Field_1 a variable containing the name of the field.

I get a message: Item not found in this collection.
The point is that I have to pass the name of the field in a variable that get a differrent value everytime the proccess is called
Any help over there?
thanks

 

[PHV]

SSField = LTable(Field_1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jbranero]

As usual with you, it works perfectly... thanks a lot!!! and congratulations for being named the best helpfull in Tek-Tips.
j