Problem with SQL script... plz help

[partizan82]

Hello everyone.

I created a script that will generate an SQL script based on search criterias that user enters in a form... A funny thing that it looks ok in a message box just before i ran it.. but then it gives me this kind of error: A runSQL action requires an argument consisting of an SQL statement... do you have any idia what it is about?

Thanks for help...
Anton

 

[llkhoutx]

Try putting your SQL string into the SQL View of a query and then run that query.

Alternatively, build you SL string in the SQL View of a query and they put it in your code.

 

[partizan82]

I did that and it works in a query, but it does not work in my sub...

anyway, i solved the problem... it was a search query and i did not put a record set to output to... that was the problem... i'm always slow in the mornings... sorry to bother you with that...

Thanks for help though...