I have a form that enables the end-user to "build" a SQL query. They can select up to 11 fields, use multiple Select conditions, and 4 sort levels. As they build the query it is put together in a txt field. The next step was to run the SQL, which I do from a command button, the code is as follow.
dim qryOutput as string
qryOutput = me.txtQry.Value ( THE TEXT BOX on the FORM)
docmd.runSQL "qryOutput" (Have tried various forms of this, used brackets and or commas)
I get an error saying the runSQL expects "SELECT" or "INSERT", ETC...
How can I run the built SQL statement?
Thanks for your help!
PW