data from access form to stored procedure

B

Beacher

Hi, I'm unsure how to go about this.. i have a form with a field for th
user to input a name.. I also have a stored procedure that needs to us
the data from the input, I am unsure how to get the data from th
txtbox of the access form to the stored procedure thats running on sq
server

(sql server 2000 backend, access 2003 frontend
 
A

Alex White MCDBA MCSE

I know this works for ADP's so I think it should work for (you have not
specified mdb/adp), if your stored procedure has a parameter of myparam1,
and by double-clicking the stored procedure it asks for this parameter, if
you have a control on your form with the same name as the parameter the
value of the control automatically gets passed to the stored procedure.
 
Top