Form Auto Submit?

[MaureenKLM]

Hello - Have FP2002 with form that submits to Access 2002 DB - all is fine.

Form1 submits to the DB and user gets a confirmation page where I can
display the form submission fields - I also display the "ID" field from the
db (unique session ID)

What I need to do is have that ID field be a parameter to a DBR that
displays on the confirmation page - I don't know how to do that without
creating an intermediate step/page that displays the form1 fields in a new
form and then the user submits that to the final confirmation with the DBR -
I don't want the user to have to submit again so.....Is there code that will
automatically hit the submit button on form2 page - refresh isn't working for
me. OR, is there another way to get the DBR to display using the "ID" field
from the 1st form's submission as a parameter?

THANK YOU!

 

[Stefan B Rusynko]

If you are using the unique session id set it as a session variable and then use it in your DBR query on your confirmation page
<%
'set the session ID as a session variable for your form to write to DB
Session("SessionID")= Session.SessionID
%>

<%
'use the session ID in your DBR snippet to get the record from the DB
' .... WHERE YourIDFieldName =Session("SessionID") ....
%>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Hello - Have FP2002 with form that submits to Access 2002 DB - all is fine.

Form1 submits to the DB and user gets a confirmation page where I can
display the form submission fields - I also display the "ID" field from the
db (unique session ID)

What I need to do is have that ID field be a parameter to a DBR that
displays on the confirmation page - I don't know how to do that without
creating an intermediate step/page that displays the form1 fields in a new
form and then the user submits that to the final confirmation with the DBR -
I don't want the user to have to submit again so.....Is there code that will
automatically hit the submit button on form2 page - refresh isn't working for
me. OR, is there another way to get the DBR to display using the "ID" field
from the 1st form's submission as a parameter?

THANK YOU!