Can anyone tell me how to put a single list box on a page and have "FName" and "LName" (from my table in database) appear in the listbox? I'm sure it's something simple, but I have no idea how to do it! Please, can someone help me?

Concatenate your FName and LName fields in a single varibale

Dim Name
Name = rs("FName") & " " & rs("LName")

and use it in your dropdown menu

<option value="<%=Name%>"><%= Name %></option>

You can also combine it in your select statement:

SELECT (FNAME + ' ' + LName) AS FullName FROM [tablename]

Or

SELECT (FNAME & ' ' & LName) AS FullName FROM [tablename]

The top one is for SQL Server and the bottom one is for Access (I believe, I don't work that much in Access). Then you can loop through the recordset using "FullName".

This is what I have. I don't get any errors now, but the option/list box is empty...What am I doing wrong?

<%
Dim adoCon
Dim rsAdmin
Dim strSQL
set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../database/mercy.mdb")
Set rsAdmin = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT (FNAME & ' ' & LName) AS FullName FROM [tblAdmin]"
rsAdmin.Open strSQL, adoCon
%>
<form name="form1" method="post" action="">
          <select name="select">
            <option value="<%=FullName%>"><%=FullName%></option>
          </select>
        </form>
<%
rsAdmin.Close
Set rsAdmin = Nothing
Set adoCon = Nothing
%>

<%
Dim adoCon
Dim rsAdmin
Dim strSQL
set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../database/mercy.mdb")
Set rsAdmin = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT (FNAME +' '+LName) AS FullName FROM tblAdmin"

rsAdmin.Open strSQL, adoCon
%>
<form name="form1" method="post" action="">
          <select name="select">
            <option value="<%=FullName%>"><%=FullName%></option>
          </select>
        </form>
<%
rsAdmin.Close
Set rsAdmin = Nothing
Set adoCon = Nothing
%>

I'LL TRY TO GIVE SOME HELP.
Sorry for the inexperienced (it's my first post)

What I see is missing is the loop thru the records in te recordset.

You have to llop thru each record in order to achieve the FName, LName pair to put it in the option of the select.

So here's th e code for before and after your line <option value="<%=FullName%>"><%=FullName%></option>

Before
<% Do While Not rsAdmin.Eof %>

I'll also change a little the select option clause just in case
<option value="<%=rsAdmin("FullName)%>"><%=rsAdmin("FullNa me")%></option>

And After
<% rsAdmin.Movenext
   Loop %>

That's all (I havn't test it, may be you find something to check)

Best regards
Tell me if it works

Make sure you have that loop inside of your select tags as well or you will get multiple list boxes.

<select name="select">
<%Do While Not rsAdmin.Eof%>
<option value="<%=rsAdmin("FullName)%>"><%=rsAdmin("FullNa me")%></option>
<%
rsAdmin.movenext
loop
%>
</select>