Variable in the field name.

[my]

Hi All,

I have one question. Usually, we can get data from table
by using rst("userid") because we know the column name
userid. Now, I have a variable to hold the column name. I
want to get data value like this rst(var1). However, I got
an error message.

Thanks.
my

 

[Manohar Kamath [MVP]]

What was the error message? Make sure that the variable does not contain any
leading/trailing spaces. A better idea is to do:

rst(Trim(var1))

Also, print out the variable and see if that field exists in the resultset.

 

[Aaron Bertrand - MVP]

What is the code? What is "var1"? What does the table structure look like?
What is the error message?

In case there's any doubt, some information is better than none.