Defaulting dropdown form to existing value

D

Dave Lagergren

I have a form that has different parts filled in by different people. All
the information is stored in a database. One stop is the service center
where the tech and service performed are selected from drop-downs. When this
form is pulled up again I would like those previously selected values to be
the default. How can I do that?
 
S

Stefan B Rusynko

Read the values from the DB
If using the FP DBRW see
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

--

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


|I have a form that has different parts filled in by different people. All
| the information is stored in a database. One stop is the service center
| where the tech and service performed are selected from drop-downs. When this
| form is pulled up again I would like those previously selected values to be
| the default. How can I do that?
|
| --
| Dave Lagergren
| Manager - Data Applications
| Wireless Management, Inc
| Specializing in cellular wireless applications
 
B

Brutus

If the values are read in from the database how are they set as the default
selection on a dropdown?
 
S

Stefan B Rusynko

See http://www.asp101.com/samples/db_pulldown_linked.asp to get the values from the DB

As for setting which one is the default (selected one) you need some other criteria from the DB
- then modify the ASP as in http://www.asp101.com/samples/viewasp.asp?file=db_pulldown_linked.asp
--

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


| If the values are read in from the database how are they set as the default
| selection on a dropdown?
|
|
| | > Read the values from the DB
| > If using the FP DBRW see
| > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > message
| > | > |I have a form that has different parts filled in by different people.
| > All
| > | the information is stored in a database. One stop is the service center
| > | where the tech and service performed are selected from drop-downs. When
| > this
| > | form is pulled up again I would like those previously selected values to
| > be
| > | the default. How can I do that?
| > |
| > | --
| > | Dave Lagergren
| > | Manager - Data Applications
| > | Wireless Management, Inc
| > | Specializing in cellular wireless applications
| >
| >
|
|
 
D

Dave Lagergren

That wasn't exactly what I needed but it pointed me in the right direction.
I set the selected field to the variable I needed and presto! I was in like
Flynn. Ok, so I have double selections but in this case that doesn't matter.
I also used the FP form bot to handle test fields and I simply put the
variable there as well in the format <% =serialnumber %> and it defaults
fine. I should note that I read in the total record before I allow the form
to be edited.
 
Top