Hi All,
Please could someone help..
I have an Insert Form with a Dynamic dropdown list populated from a recordset. What I would like to know or do is take the value from the dropdown menu currently <%=(rsEmployeeRecordset.Fields.Item("FullName".Value)%> and pass this to the acknowledgement page which will then use another table in Access to insert or replace the "FullName" with the relevant "EmailAddress" stored in the table into ASPmails EMto: codeline.
Please could someone recommend a tutorial or exstension as I am at the end of a long project and I am unable to get this working..
Regards
Robin...
NT2000/UD4/IIS5.0/ASPmail3.0/Access97

You need to have a insert-retrieve ID form rather than a simple insert form. This will enable you to create a session variable of FullName (better to use a employeeID if you have it) that you can use to filter a recordset on your acknowledgement page and there for get the email address for that person.

You can get this extension from www.basic-ultradev.com and here is a link for help on getting it to work
www.basic-ultradev.com/exthelp/Insert-RetrieveIDHelp.htm

Vinny

Thank you Vinny I will give it a go..and let you know how I get on..many thanks.

Regards
Robin...

Simple enough.

I recommend changing the initial FORM method to POST.

Assuming the dropdown list's name is comboUser, create a recordset on the next page that uses:

SELECT fldEmail FROM tblUsers WHERE fldFullName = Request.Form("comboUser"

And boom, you have the recordset of the user who was selected on the previous page.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])