Show two Fields in List Window

[tomhughes]

Does anyone know how to show two fields from a Recordset in one List box ?I have a query that shows a list of Dates, and number os slots available for training for those dates. Can I show both of these fields in one List Box ???

 

[mlawson]

Tom,

Couldn't you create a child system where your user selected the date from the first box and that would automatically display the number of places available in a resulting second dropdown list? Or is that being too clever.

The other answer is that you should be able to create an option type selection by hand coding your recordset names, but they'd better coincide by ID or something or you'll get lots of unhappy chappies.

<option value=&quot;<%=(rs.Fields.Item(&quot;EventDate&quot.Value)%><=&quot;<%=(rs.Fields.Item(&quot;EventPlaces&quot.Value)%&quot;>Event Date and Available Places<option>

IF that works, I'll eat my hat!

M

 

[Cheech]

Did you want salt and pepper with that M, why wouldnt it work? Live long and make your kids suffer..

 

[mlawson]

Mmmm...yummy!

Did it work?

M

Old Scottish proverb-
&quot;Man who live in glasshouse, should undress in basement&quot;

 

[Cheech]

With my set up it was ok.

I was able to do something like

<SELECT>
<OPTION value=&quot;<%=Response.Write(rs.fields.item(&quot;lastname&quot.value & &quot;, &quot; & rs.fields.item(&quot;firstname&quot.value%>&quot;>
</SELECT> Live long and make your kids suffer..