You have the bombo box as a reply to your other post?
To create this list all you need is an onChange event in the <select> tag. When a user makes a selection from the combo box it runs the onChange event, submits it's self then reloads the page creating the list.
1..Change your select tag to include:
2..Now put a condition up top somewhere, has the form been submited? if so it will run otherwise be ingorned
showList = false
if request.form("userList") <> "" then
'get all records where not = combo box selection
sql = "SELECT id, UniqueName, F_NAme, L_Name, MI FROM tUser WHERE id <> " & request.form("userList") & ";"
set getInfo = conn.execute(sql)
'create show list variable
showList = true
3..Now where ever in the body of your page you want to see the list; you say:
;;;names should be shown in the check boxes
I dont understand this part. I only know of one type of checkbox, you cant put a names in them.
Q..Do you want check boxes adjacent to each name?
Anyhow, to show your list
<% if not getInfo.EoF then
do until getInfo.EoF
response.write "<tR><td>" & getInfo(2) & "</td><td> </td><td>" & getInfo(3) & "</td></tr>"
this will give you a list in a table each row being' F_NAme' space 'L_Name'. If you want a checkbox adjacent to each name, throw a checkbox tag in the loop just before getInfo(2)
Wind is your friend