
October 24th, 2003, 06:02 PM
|
|
Contributing User
|
|
Join Date: Aug 2003
Posts: 61
Time spent in forums: 15 h 10 m 3 sec
Reputation Power: 6
|
|
Dynamic Initial Value for list box???
Alright I have a problem. What I want to do is setup an intranet page to update a record in an access xp database. I'm using Dreamweaver MX. I have the search page, that passes a search parameter to a results page that finds which record I want from my database. Then I have that results passes the URL parameter to an update page that has a filtered recordset. This update page has a table that displays all the fields for the record I searched for originally. All the information is presented in text boxes that I can type in, changing any information I want for this record. Now, what I want to do is change some of these text boxes to list/menu boxes. However, I want the initial value of this list box to be the value that is from the filtered recordset. I want to do this so if I go to update the record I can just pull down the menu to change the value, but I want the initial value to be whatever is in the record.
The Code for the table looks like this:
<td> <input type="text" name="Name" value="<%=(Recordset1.Fields.Item("Name").Value)%>" size="32">
I want it to look something like this:
<select name="select" size="1">
<option><%=(Recordset1.Fields.Item("Location").Value)%></option>
<option>value2</option>
Did that make any sence?
Thanks!
|