How to use multiple forms to populate a record before writing

  • Thread starter Thread starter MMJII
  • Start date Start date
M

MMJII

Hello All,
I have a form that gets contact info, and then 3 other forms that perform
cost analysis surveys. I need a way to get the info from the contact page
and then the results from the anaysis page(s) befor the actual submit to
create the record.
Is there a way to get the contact info from the contact info form without
using submit control before I can get the other results from the subsequent
page(s) then submit the info for writting?

Thanks for any ideas.
MMJII
 
You can store values in a session variables, then at the end of write all of the session variables
to the database.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================
 
You must be hosted on a Windows IIS web server w/ASP and Access (Excel is not recommended) to
process the form, not the FP Extensions in order to use Sessions.

first form has name, address company, email

On your second form page capture the fields like

<%
Session("FullName") = Request.Form("FullName")
' Note rename your name field to FullName or something other then Name.
Session("Address") = Request.Form("Address")
'etc.
%>

2nd form has fld1, fld2, fld3, result1, result2

Do the same on Page 3 and 4 to capture the fields from the previous forms.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================
 
Back
Top