INSERT INTO

[warway]

I have an sp that inserts a record from one table to another based on a
parameter that works fine. How can I use a field on an MSAccess form to be
the parameter? I can get the sp to run from the form but only to prompt me
with the parameter required I want this to be the current record and to do
it without asking.

Thanks in advance for your help

Warway

 

[MGFoster]

I have an sp that inserts a record from one table to another based on a
parameter that works fine. How can I use a field on an MSAccess form to be
the parameter? I can get the sp to run from the form but only to prompt me
with the parameter required I want this to be the current record and to do
it without asking.

Add the parameters in an ADO command that runs the SP.