Add the TicketNo value from parameter passed on the survey.asp page as:
<% TicketNo=Request.QueryString("tn") %>
to the form on survey.asp form as a hidden form field
<input type ="hidden" name="TicketNo" value="<%=TicketNo %>">
Above Presumes your DB has a field in it for the Ticket Number named: TicketNo
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| Hello Stefan,
| First, thank you for replying.
| I am new at this, so please bear with me.
| The link in the email shows the ticket number, when you click on the link
| from the e-mail it takes you to the correct page: (survey.asp)
| But I still can't pass the data to access when the submit button is pressed.
| It does pass the data from the other fields.
| I tried a few different ways, (ie code in the ticket number field, next to
| it, at the top of the page, etc) but I can't seem to pass the data.
| Can you explain where exactly the code should be in the survey.asp form?
| Thank you in advance for your help, I really appreciate it.
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Your link should be:
| >
| > servername/application/survey.asp?tn=ticketnumber
| >
| > And you capture the parameter value on the page survey.asp using
| >
| > <% TicketNo=Request.QueryString("tn") %>
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Hello,
| > | Can anyone tell me how I can capture data from a hyperlink and bring the
| > | data into a form.
| > | Here is what I am trying to accomplish.
| > | I am using frontpage 03 and Access 03.
| > | Once a ticket has been marked closed , and e-mail is generated to the user
| > | with a url to fill out a quick survey.
| > | I need to have data in this hyper link refer back to the ticket number; so
| > | when the user completes the survey, the data from the survey is related to
| > | the ticket.
| > |
| > | ex: servername/application/survey.asp?ticketnumber
| > |
| >
| >
| >
