Problem with SQL script... plz help (1 Viewer)

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

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.

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...