| re: stored procedures with parameters (in .adp)
Hi
You may be better posting to an Access Newsgroup such as
microsoft.public.access.adp.sqlserver.
Not being an access person I don't know the solution, but I would expect
that you can pass values between forms and therefore use them as parameters
to the stored procedure, I would also suspect that if the form is open you
can still access the field values if referenced correctly.
John
"zlatko" <zlatko.matic1@sb.htnet.hr> wrote in message
news:cn80pa$kfj$1@ls219.htnet.hr...[color=blue]
>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
>
>
>[/color]
| 
