Recordset Problem with Access

[nordine5]

I have created a log in page, which works and the information is routed to an
Access database; I have also created a confirm page which is supposed to tell
user the following:

========================================
Thank you (first name) (last name) for registering.

Your access details are as follows

Username: (username)
Password: as you entered

Click to login
=========================================

The problem is that everytime I try to register, the confirm page always shows
the first name, last name, and username of the first entry in the database, and
not the current person who registered.

Here is what I put on the confirm page in Dreamweaver, after creating a
Recordset.

====================================
Thank you {rsConfirm.myFirstName} {rsConfirm.myLastName} for registering.

Your access details are as follows

Username: {rsConfirm.myUsername}
Password: as you entered
=====================================

Thanks

[twocans]

this should be of some use. on inserting a record the proof page is filtered
by retrieving autonumber from the insert page.

[url]http://www.tom-muck.com/extensions/help/insertretrieve/[/url]





"nordine5" <webforumsuser@macromedia.com> wrote in message
news:d2qlad$i9m$1@forums.macromedia.com...

>I have created a log in page, which works and the information is routed to
>an
> Access database; I have also created a confirm page which is supposed to
> tell
> user the following:
>
> ========================================
> Thank you (first name) (last name) for registering.
>
> Your access details are as follows
>
> Username: (username)
> Password: as you entered
>
> Click to login
> =========================================
>
> The problem is that everytime I try to register, the confirm page always
> shows
> the first name, last name, and username of the first entry in the
> database, and
> not the current person who registered.
>
> Here is what I put on the confirm page in Dreamweaver, after creating a
> Recordset.
>
> ====================================
> Thank you {rsConfirm.myFirstName} {rsConfirm.myLastName} for registering.
>
> Your access details are as follows
>
> Username: {rsConfirm.myUsername}
> Password: as you entered
> =====================================
>
> Thanks
>