As part of the insert action define something from the form
that is likely
to be unique such as emailaddress, and assign it to a session
variable like
this
<%
session("svemail")=request.form("emailfield")
%>
Then on your invocie page simply filter the records by the
session variable,
and select the order to be in DESC order.
--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver
Valleybiz Internet Design
www.valleybiz.net
"BAPWEB" <webforumsuser@macromedia.com> wrote in
message
news:e6p2q5$lj6$1@forums.macromedia.com...
>I am new at this - so my aplogies - I am using
Dreamweaver, ASP and
>Access - I
> am doing a form registration page and upon submit, the
submitter is sent
> to a
> invoice page which contains some of the data they just
submitted. How do
> I
> cherry pick the record that was just created on the
previous registration
> page
> in order to show some of it on the invoice page? I
assume I will have to
> create a variable from the value of one of the form
fields on the
> registration
> page, then use that to call the correct record on the
invoice page, but I
> have
> no idea how to do it in Dreamweaver, or the syntax if I
need to code it by
> hand. Any help would be greatly appreciated. I have been
stuck on this
> for
> over a day.
>
2
Replies
AdChoices