<Select> Drop Down Box Question

Results 1 to 2 of 2

Thread: <Select> Drop Down Box Question

  1. #1
    Join Date
    Dec 1969

    Default <Select> Drop Down Box Question

    I am going to display data in drop down lists. Usually when I do this, my data is in a table with the items stacked on top of each other in the table rows. So all Item1s go into one &#060;select&#062;, all Item2s go into another &#060;select&#062;, etc.<BR><BR>But the data I want in my &#060;select&#062; drop downs now is all in the same row. So I would want Item1, Item2, Item3, etc from row one in one &#060;select&#062; box, then Item1, Item2, Item3 from the next row in another &#060;select&#062; box. <BR><BR>Is that possible?

  2. #2
    Join Date
    Dec 1969

    Default YUP

    Just do a normal query... then...<BR><BR>while not rs.eof<BR> for each fld in rs.fields<BR> str = str & "&#060;option value=" & rs(fld) & "&#062;" & rs(fld)<BR> next<BR> rs.movenext<BR>wend<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts