Execute Stored Procedure

[eddied]

if some one could help i would appreciate it!
I am currently trying to use
cmd.openstoredprocedure "Proc_name" to execute a sql store procedure in access project i need this to run which propergates a form than after the stored proc runs i use a openview to view the form that part works fine. it's when i use the docmd it propergates the form but gives me and error 7874 microsoft access can't find the object and my cmd proc does't continue thru.
i hope i explained enough.
please help new at this!
thanks.

 

[Smart]

Try something loke this

Dim Con As ADODB.Connection
Dim Rst As ADODB.Recordset


Set Rst = Con.Execute("Exec Yourstoredprocedure")
Rst.Close
Con.Close