I have a classic ASP page that has a list box populated by a record set. The selected Value must be as it is. However, the record set contains another field called 'tel' that I want to use to populate a text box simultaneously. Would have been a simple task if I could change the Value to <%= RS("tel") %>, but I cannot. I need to search the record set based on "first_nm" and "last_nm". How do I do it?
<select name="req_pvisitname" >
Do Until RS.EOF
<option value="<%= RS("first_nm") %> <%= RS("last_nm") %>"><%= RS("last_nm") %>, <%= RS("first_nm") %></option>