I've got a few SQL Stored Procedures. I want to use one to insert Form data into a few SQL Tables.
I have the page created that the users fill in and a Submit button.

Question: I don't want the Submit Button to submit to a New Page, so how does the Submit work?
I've added the Command Object to the Stored Procedure, but am a bit confused on how to get the Form submitted to that.

Thanks
jeffrey

If you are useing an actual submit button:

<input type="submit" name="Submit" value="Submit">

Make the form submit back to the same page:

<form name="form1" method="post" action="ThisPage.asp">

Then place a condition around the command(stored procedure code), something like:

<% If Request("Submit" <> "" Then %>
<%
COMMAND CODE
%>
<% End If %>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thanks...

I got that to work now.