Running a stored procedure from Access form

[Guest]

Good morning,

I've built an "edit record" form. The controls are all unbound, and are
prefilled with the existing data using a recordset that's opened from a
stored proceture [rst.open("exec ...")]

The "save" procedure in this form uses a different stored procedure to write
back to the table. First I build an arguments string based on the values of
my form items, then I execute DoCmd.RunSQL("exec ..."). Unfortunately, when I
do this I get the error: "There was a problem accessing a property or method
of the OLE object". How can I get this to work?

 

[Guest]

Nevermind! There was something odd in my exec string. All set!