Asp question

That is how I had it before.  It works that way. The problem is when I go the Quote Detail page (quotedetail.asp) I have on that page a form for them to fill out any notes for that quote and update it to a database.  All this worked fine. 

I use the form submit button which takes you to a page (QuoteNoteAdd.asp) that does the actual database addition of the note. 

From that page when I go back to the QuoteDetail page I loose the quereystring.  Is there a way to reset the query string in QuoteAddNote.asp so I can get back into qoutedetail.asp.  This is why I thought of using session.

Thanks that did it.  I appreciate it very much.  Do you know how to populate a  form text box  after reading  a datebase.

Last think  I need to know.  You have been very helpful.

Thanks again.

I have a form called form1 with 2 textboxes.

I do the following code:

    DBPath = Server.MapPath("/database/cejco.mdb")
   
    Set MyConn = Server.CreateObject("ADODB.Connection")
    Set MyNS = Server.CreateObject("ADODB.Recordset")
    MyConn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & DBPath 
    SQL = "SELECT * From QuoteDailyNote Where QuoteDailyAuto = " & quoteAutoID
    'open main rs for populating participant page
    MyNS.Open SQL, MyConn, adOpenKeySet, adLockPessimistic, adCmdText   

If MyNs.Recordcount > 0 Then
   
    MyNS.MoveFirst
    Do While Not MyNS.EOF
        Session("QuoDlyAutoID") = quoteAutoID
        x = MyNS.Fields("QuoteDailyHeader")
        document.form1.txtNoteDB.value = myNS.Fields("QuoteDailyNote")

I am assuming the last line (document.form...) is incorrect.
I am not sure what you were saying.

Thanks,

Bob

%>