G
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?
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?