DBR field as default value on form

M

MaureenKLM

FP 2002 with Access 2002 web on Windows server

When users submit FORM1 on my site, the info goes into Access and I use a
DBR for the confirmation page (snagging the autonumber ID field too). Below
this DBR/form confirmation section, on the same page, I have a subsequent
FORM2 - I want to set one of the fields on FORM2 to have a default value of a
field value taken from the DBR section on this same page just above the
FORM2. I know I've seen the code for this - I've searched but haven't found
the code that works - PLEASE HELP!

Thanks!
 
S

Stefan B Rusynko

Within the DBR region at the top set an ASP variable to your field value
<% newfield=FP_FieldVal(fp_rs,"databasefieldname"), %>

Then w/i the form just enter the ASP variable in the form field value

<input name="newfield" type="text" value="<%=newfield%>">
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| FP 2002 with Access 2002 web on Windows server
|
| When users submit FORM1 on my site, the info goes into Access and I use a
| DBR for the confirmation page (snagging the autonumber ID field too). Below
| this DBR/form confirmation section, on the same page, I have a subsequent
| FORM2 - I want to set one of the fields on FORM2 to have a default value of a
| field value taken from the DBR section on this same page just above the
| FORM2. I know I've seen the code for this - I've searched but haven't found
| the code that works - PLEASE HELP!
|
| Thanks!
 
M

MaureenKLM

Thanks very much! I had to eliminate the last comma in the setting variable
cluase and it worked beautifully. THANKS!
 
S

Stefan B Rusynko

Great
- yup, the last comma was a typo
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Thanks very much! I had to eliminate the last comma in the setting variable
| cluase and it worked beautifully. THANKS!
|
|
| "Stefan B Rusynko" wrote:
|
| > Within the DBR region at the top set an ASP variable to your field value
| > <% newfield=FP_FieldVal(fp_rs,"databasefieldname"), %>
| >
| > Then w/i the form just enter the ASP variable in the form field value
| >
| > <input name="newfield" type="text" value="<%=newfield%>">
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | FP 2002 with Access 2002 web on Windows server
| > |
| > | When users submit FORM1 on my site, the info goes into Access and I use a
| > | DBR for the confirmation page (snagging the autonumber ID field too). Below
| > | this DBR/form confirmation section, on the same page, I have a subsequent
| > | FORM2 - I want to set one of the fields on FORM2 to have a default value of a
| > | field value taken from the DBR section on this same page just above the
| > | FORM2. I know I've seen the code for this - I've searched but haven't found
| > | the code that works - PLEASE HELP!
| > |
| > | Thanks!
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Auto Submit? 1
Parameter in DBR 6
DBR Form 1
DBR Error Class Not Registered 9
DBR Fails for some 2
Form field value passed 1
DBR Dropw Down Search Retains selection after submit 2
Auto submit form 0

Top