trouble getting value

[Ziggy1]

Kinda confused, can someone help me with this....

                    For Each fld In db.TableDefs("tblLabelFile").Fields
                    
                          FldNme = fld.Name
                          FldNme = "rs!" & FldNme

the above tells me the field name, which I then want to use to return the data of that field. I am looping through the columns so I can append the data to another table in a list.


eg if I just hard code rs!client I can get the value, but the variable is just returning rs!Client

 

[Ziggy1]

I always do this, as soon as I post, I figure it out.



this gets me the value.... FldNme = rs.Fields(FldNme)