action stored procedures with parameters

[Sylvain Lafontaine]

And how are you calling these stored procedure in your code actually?

S. L.

 

[zlatko]

I use a stored procedure that is calling several other stored procedure
which update or append values in several tables. All of them are stored
procedures with input parameters by which they filter rows to be updated or
inserted into other tables.
Filtration is based on certain actual values on forms (form with several
subforms).

My question is following: How to pass parameters to those stored procedures
that are triggered by a button?
Those stored procedures are not recordset of forms, so I can't pass it using
Input Parameters property of forms (or I can?).

Thanks.

Zlatko

 

[zlatko]

Actually, not using code, but using On Click property of buttons...I haven't
used code till this moment, because, Access macros were enough...

 

[Sylvain Lafontaine]

Then you just have reached the point where macros are no longer enough.
S. L.