INSERT INTO

's Computer Specifications

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

's Computer Specifications

warway wrote:

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

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to insert a where clause in Insert Into... statement?		Microsoft Access Queries	9	10th Dec 2004 12:27 PM
Very simple INSERT INTO with a DateTime parameter -> "Syntax Error in INSERT INTO statement"	loquak	Microsoft ADO .NET	3	30th Nov 2004 08:41 PM
Insert cell/format/text/fontsize and auto insert into header?	=?Utf-8?B?VW5mdXJsdGhlZmxhZw==?=	Microsoft Excel Programming	2	3rd Nov 2004 06:39 PM
Insert \| File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet	Oda Yujiro	Microsoft Outlook	4	17th Jun 2004 01:53 AM
How to insert record into SQL 2k by Insert Statement	Mullin Yu	Microsoft C# .NET	2	25th Nov 2003 09:50 AM