INSERT INTO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

warway - 24 Feb 2004 15:03 GMT

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

Reply to this Message

MGFoster - 24 Feb 2004 17:05 GMT

> 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.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message