Hi, sure it's a silly question, I know I've done this before but can't see wood for trees.
I need to reference several field names in a recordset in turn, in a loop. I have the recordset, and using the field name directly works e.g.
str = rst![FieldA]
However, if I try and capture the name of the field first it doesn't e.g.
strName = "FieldA"
str = rst![ & strName & ]
What am I missing please? Thanks!
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
I need to reference several field names in a recordset in turn, in a loop. I have the recordset, and using the field name directly works e.g.
str = rst![FieldA]
However, if I try and capture the name of the field first it doesn't e.g.
strName = "FieldA"
str = rst![ & strName & ]
What am I missing please? Thanks!
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
