Recordset variable?

[jjyxk845]

Hi I hope this will have a simple answer.

I have the following code.

output = rs!age33

but what i want is to use a variable instead of age33


this is what i hoped would work but didn't and should help explain things
clearer.

lookup_age = 33 

Query_Age = "Age" & Lookup_Age 

output = rs!query_age

this way i can select any "age" can anyone help

 

[Norie]

I think we would need to know more about how you have created the recordset but perhaps something like this might work?

rs.Fields("age33")

Where you could replace the "age33" with a variable.

 

[jjyxk845]

That worked great Thank you very much.

this was how i defined the recordset

Query = "SELECT * FROM list WHERE Name='" & Lookup_list & "'"
rs.Open Query, Cnn, adOpenForwardOnly, adLockReadOnly, adCmdText