Populating a list box from a SQL server table

[Zukkster]

I'm having trouble populating a list box from a SQL server datasource.

I can link the table to my access database and set it to be the RowSource of the list box, but when I do this it takes a little too long to refresh the data.

If I populate the table using code, will it be quicker? If so can anyone help with the required code.

Thanks

 

[vbajock]

There's a lot of variables in this. Generally ADO code will be a lot quicker, especially if you can work with stored procedures.