Name=objRS("FirstName") & objRS("LastName")

Name now has both first and last name or it is concatenated. Is this what
you were looking for?

If it is just loop through the RecordSet(objRS) and place the cat form of
the data into the list box.

Hope this is what you were looking for

Warren

----- Original Message -----
From: "Lane Boyd" <laneboyd@b...>
To: "Interdev_Programming" <interdev_programming@p...>
Sent: Thursday, October 26, 2000 8:21 AM
Subject: Concatenation of DB info


> Hi all,
>   Does anyone know how to display multiple rows of info in a DB powered
> listbox?  (i.e. Last Name, First Name M.I)  All of this info is in the
> same table, but not the same row.  How do I piece it all together in the
> DB powered listbox.  Thanks in advance for your help.
>
> Lane
>