Refer to recordset field by string

[John J.]

If I have the following code,
rs!MyTestField = "Testval"
How can I refer to MyTestField as a string?
I tried things like rs!(strTest) and rs![(strTest)] but I can't get it to
work.

Thanks,
John

 

[RoyVidar]

If I have the following code,
rs!MyTestField = "Testval"
How can I refer to MyTestField as a string?
I tried things like rs!(strTest) and rs![(strTest)] but I can't get
it to work.

Thanks,
John

Almost there, try

rs(strTest)

Or, what I would use, which is a bit more explicit

rs.fields(strTest).value

 

[sweet_dreams]

Hi John,

try this:
rs.fields("field_name")
or
rs.fields(field_index_number)

Regards,
Sebastian

 

[John J.]

Thanks guys!