Using a variable to define a column name
If anyone can assist, it would be much appreciated. I am writing a search form that currently has 3 combo boxes. What I am trying to do is use the value of one of the controls as a variable to SELECT a column in a query. I can't seem to make it work. I know that I can pass control information as query criteria, but can I use a variable in a select statement? Is there anyway to use the value from my combo box to retrieve the column with that name?