Listboxes and Databases

I have a database table with a First Name Field and a Last Name field. What I want to do is load both of those fields into a listbox, but in a certain format. I want an Item in the listbox to appear as follows: Last Name, First Name (Doe, John) and I want it pulled from a database. Thanks in advance for the help


Josh


Comments

  • Assuming you already know how to get the fields from the database (I don't), you can use the following to put it in the listbox


    PersonsName$=LastName & ", " & FirstName

    List1.AddItem PersonsName$


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories