Execute a stored procedure from a form, & pass in a parameter? 1

[jgoodman00]

I am designing forms, & I want to have a stored procedure execute when a record is updated. I am using the before_update event of the form. I have created an Update sp, which requires one parameter (the primary key). I understand that you can execute an sp with parameters using the syntax of "exec spName, parameters". However I dont know how you call this from an Access form. It looks like you call an sp via the "DoCmd.OpenStoredProcedure" action. However this does not look like it will pass parameters.


Any suggestions?? James Goodman

 

[tlbroadbent]

Check the following articles.

http://support.microsoft.com/support/kb/articles/Q131/5/34.asp

http://support.microsoft.com/support/kb/articles/Q112/1/08.asp

http://support.microsoft.com/support/kb/articles/Q124/3/91.asp

http://support.microsoft.com/support/kb/articles/Q232/4/93.ASP

Check faq701-721 for more Access develop resources. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jgoodman00]

I have finally had a chance to look at those articles. I could use them, but I would prefer it if I could use the OpenStoredProcedure from within access. I am sure a few weeks back I managed to get this to work, but I cannot remember how.

Is it possible to use the OpenStoredProcedure action, & pass in parameters??


James Goodman