>Hi,
>Sorry, I still not understand,
>How to load the records in client table into the listbox ?
>

I misunderstood your original message. I thought you already had an array containing the data you wanted to display. Since you don't, you have a number of choices.

Possibility #1:

Use a query (SQL-SELECT) to copy the data from the table into an array and then use an array RowSourceType as I explained before.

Possibility #2:

Use RowSourceType 6-Fields and list the fields you're interested in as the RowSource. For example:

RowSource="MyTable.LastName, FirstName"

Possibility #3:

Use a query (SQL-SELECT) to copy the records and fields you're interested in into a cursor. Then use RowSourceType 2-Alias, and set RowSource to the newly created cursor.

There are several other options as well. Which one will work best for you is hard to say without knowing more about your application.

Tamar