Pass List selected item as a Field Name in Select Query

[celiowin]

Hi,
I have a listbox containing field names and i would like to pass the selected item to the SELECT QUERY > Field.
But when i hit the query button on the form it returns the result containing the selected field name from the listbox instead of the data in that column.



My SQL View looks like
SELECT Forms!subform!mylist AS Expr1 FROM myTable

Am i passing the parameter from the list to the field as a wrong data type?

[pbaldy]

To my knowledge you can't do that. It did what I would have expected. The only way I know of to do what you're trying to do is build the SQL in VBA and either use it there or use a DAO QueryDef to change the SQL of a saved query.

[celiowin]

So the DAO QueryDef will overwrite my the setup in SELECT QUERY in access?
Then i'll need to switch from ADO to DAO

[pbaldy]

Depends on what you want the SQL for; some things I would just use the SQL in code, others I'd set a query to the resulting SQL.

[rpeare]

You can't do it directly but depending on what you're doing you can construct a SQL statement and process the contents

For instance let's say you have a form called frmTest
on that form you have a field TestField

You have a table named tblTestData
in that table you have the fields
DATAID (autonumber)
DATATEXT (text)
DATANUMBER (number)

if you wanted to construct a sql statement on a button click (for instance) you could have

dim ssql as string

ssql = "SELECT " & forms!frmtest!testfield & " FROM tblTestData"

then if you were to process this SQL string as a recordset you could do what you wanted, I haven't ever done it but you might be able to save the SQL string as an actual database object.