Hi,

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?

Thanks,

Tara

Yes.

You can make a list of column names that are meaningful to the user by populating the list yourself, or you can use the actual column names using a look up on the table you are querying.

Will you use the primary key to look up the records, or some text value?

How are you using the column? It sounds like you are allowing the user to look for a value in their choice of columns. If that is the case, then your link criteria might look like:

sColumnValue = Me.cboColumn
sOtherValue = Me.cboOtherValue

sLink = "[" & sColumnValue & "] = " & "'" & sOtherValue & "'"

That is how you would do this with a text value. If you were using a numeric value, you would use:

sLink = "[" & sColumnValue & "] = " & sOtherValue

Does this help?



mmcdonal