INSERT INTO

  • Thread starter Thread starter warway
  • Start date Start date
W

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
 
warway said:
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.
Click to expand...

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