Dynamically referencing fields in a recordset

[WatDisDo]

Hi Everyone

I am attemting to access the fields in a recordset using a field name derived dynamically, i.e. along the lines of :

dim somevar as string
.
.
.
rs.fields(somevar) or rs!somevar

This obviously doesn't work, as the methods seem to expect literal values rather than dynamic for field names. Has anyone any ideas, or am I missing something here.

Thanks in advance X-)

Malcolm.

 

[SIG357]

I do believe you are on the right track. You can reference fields by name, which you can create dynamically and set in a variable. You just have to say

rs.Fields(somevar).Value