RecordSelect Field Name

[Ross Lewis]

I am trying to get a value from a field whose name is a variable.

Such as:
variable = "custname"
rs!variable

Is this possible?

 

[Ross Lewis]

Solution Found:

rs.Fields(variable).Value

 

[Duane Hookom]

You can use
rs(Variable)