There is prolly a simple answer to this, but it is driving me crazy...

After I've done a successful query of the SQL db, I want to put the results into variables so that they are easier to use. This is the way I normally do this (which is working):

varBookTitle = objRSBooks("Title")

Instead, I want to use a variable to specify the fieldname, which is being passed from user input; it would be something like this, but the syntax is wrong:

varBookTitle = objRSBooks(" & varMYFIELDCHOICE & ")

Does anyone know the exact syntax? I have tied so many things....

Thanks,
WebGrrl

varBookTitle = objRSBooks(varMYFIELDCHOICE)

Awesome, that works like a charm

Thanks,
WebGrrl