Form data - drop down values/display option

[Tom Petersen]

I have a drop down box where the choices are populated from a database
query, this part works fine:
<option value><% = strEmail %></option>

I was wondering if it is possible to keep the value as strEmail, but make
the display Last_name, First_name. So when a user looks at the list, they
will just see the names, but when the form is submitted, the actual email
address associated with the name is passed along.

Long story short, there is probably a better way to do what I am trying to
do, but I was hoping for a nice simple solution to this problem! :)

TIA

[TomB]

<option value="<%=strEmail%>"><%=strLName & ", " & strFName%></option>

"Tom Petersen" <pe****@sdsd.sdbor.edu> wrote in message
news:uX**************@tk2msftngp13.phx.gbl...

I have a drop down box where the choices are populated from a database
query, this part works fine:
<option value><% = strEmail %></option>

I was wondering if it is possible to keep the value as strEmail, but make
the display Last_name, First_name. So when a user looks at the list, they
will just see the names, but when the form is submitted, the actual email
address associated with the name is passed along.

Long story short, there is probably a better way to do what I am trying to
do, but I was hoping for a nice simple solution to this problem! :)

TIA

[Tom Petersen]

Thanks!

That is exactly what I wanted!!!

"TomB" <sh*****@hotmail.com> wrote in message
news:#8**************@tk2msftngp13.phx.gbl...

<option value="<%=strEmail%>"><%=strLName & ", " & strFName%></option>

"Tom Petersen" <pe****@sdsd.sdbor.edu> wrote in message
news:uX**************@tk2msftngp13.phx.gbl...

I have a drop down box where the choices are populated from a database
query, this part works fine:
<option value><% = strEmail %></option>

I was wondering if it is possible to keep the value as strEmail, but make the display Last_name, First_name. So when a user looks at the list, they will just see the names, but when the form is submitted, the actual email address associated with the name is passed along.

Long story short, there is probably a better way to do what I am trying to do, but I was hoping for a nice simple solution to this problem! :)

TIA