Ive been messing with code for hours now but nothing works.

What im trying to do is pass the OrderID of products (bound to the checkbox) to a confirmation page which will display the rest of the information associated with the OrderID (name, qtny, price etc) before sending it off as a string for emailing.

Does anyone understand what I mean and point me in the right direction?

any help would be marvellous ...

Hi Paleface,

Find the UD code on your form insert page where it says:
'append the query string to the redirect URL

Then change all (in my example there are 4)of Request.QueryString to Request.Form. A simple change, but it works for me. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> Note in the following example I have done that and commented the code so I remembered what I did:

' append the query string to the redirect URL 'jean-marie changed Request.QueryString to Request.Form to pass form values to the next page.
If (MM_editRedirectUrl &lt;&gt; "" And Request.Form &lt;&gt; "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.Form &lt;&gt; "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.Form
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.Form
End If
End If

Hope that helps!

Jean-Marie Bonnar

Edited by - Jean-Marie on 22 Mar 2002 18:22:05

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi Paleface,

Find the UD code on your form insert page where it says...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Um... I'm sorry, perhaps I wasnt clear enough. My fault.

This isnt an insert page, and im handcoding this ...

what I have is a checkbox (in a form) called "Delete" and bound to the value of that checkbox is the orderID from a recordset on that page.

The orderID is a unique field that also contains information such as Product, Price, Quantity in its row...

This page also has a multiple update and multiple delete functions combined on it, so I cannot mess with the checkbox value ... only pass it on.

Im passing it on to a page that will display the associated information of the OrderID ... except thats where im having the problem - getting the information from the OrderID.

Is there some syntax or a tutorial somewhere that will help?

in retrospect, what I think im asking for is: are there any ways of selecting specific db rows?

This may be way simple or not... but I cant work it out.