Setting unique Session Variable

M

MaureenKLM

FP 2002 - MS Access DB

I have site for registration which includes several form pages - All but one
form submits to a different table in the Access DB - The exception is a form
that asks visitors if they want to register another or finish up and pay
(DECISION form doesn't "submit" to the database)

FORM1 submits to DB and moves user to FORM2. ON FORM2 I am able to get the
AutoNumber field from the submission made on FORM1 using a <%=
FP_SavedFields.item("ID")%> thanks to Spiderwebwoman! All is good so far.

I now need to bring my visitors to other form pages which will have a field
using this SAME ("ID") number - I need to carry the autonumber field value
throughout the session. It does ot appear to be a session variable already -
or I'm just not doing all that I should to be able to use it correctly.

I tired to create a SESSION VARIABLE using this value but was unsuccessful.
I am desperately in need of very detailed HELP in how to create this as a
session variable that I can use on various form pages throughout the visitors
session.

CAN YOU HELP or direct me to some documentation?
THANK YOU!
 
R

Ronx

You can set the session variable where you display the Autonumber field,
so

<%= FP_SavedFields.item("ID")%>

becomes

<%
session("savedID") = FP_SavedFields.item("ID")
response.write(FP_SavedFields.item("ID"))
%>


To use the session variable on other pages:

variableName = session("savedID")
 
M

MaureenKLM

THANK YOU!

Ronx said:
You can set the session variable where you display the Autonumber field,
so

<%= FP_SavedFields.item("ID")%>

becomes

<%
session("savedID") = FP_SavedFields.item("ID")
response.write(FP_SavedFields.item("ID"))
%>


To use the session variable on other pages:

variableName = session("savedID")


--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Auto Submit? 1
DBR Fails for some 2
DBR Form 1
Session variable from FP form (sorry for duplicate) 3
Session help 8
Parameter in DBR 6
DBR field as default value on form 3
Global.asa and current users counter 2

Top