What are the limitations of stored procedures. I have a button on the form that i need to make it edit 2 different forms. This is very easy using the property command to switch between eep's. I had the idea to switch between stored procedures and keep the code inside the database and maybe learn how to use stored procedures. When I run the form and push the button that is running the Procedure i get a "Syntax is incorrect for return 2045" but if trace it from the R> no error.
The code for the procedure is very simple and really does not need to return any value. EDIT USING SomeFormName Do some other stuff when exiting the form Victor Timmons Tiz's Door Sales, Inc 425-258-2391

