populate the contents of a list box by a MS SQL query?

[Goha]

How do i populate the contents of a list box by a MS SQL query?

for example I want the list box to be populated by the listing of all the user tables in the database publisher....

Thanks in advance

 

[BPMan]

if your recordset is called res you would do the following

Do Until res.EOF
lstResults.AddItem res!NAME
res.MoveNext
Loop