CODEWITHSUNDEEP
vbams-access-2013
Tony
Tony

Reputation: 21

How to populate listbox from linked table?

I am working with a database that has an Excel table.

I created a form and want to populate a listbox with the contents of the linked table when the form loads.

Upvotes: 0

Views: 2233

Answers (1)

Tony
Tony

Reputation: 21

Thanks to Andre I found a working solution which is shown below:

Listbox.rowsource = "SELECT tablename.fieldname FROM tablename"

This pulls record(s) from my table and shows them in the listbox. For simplicity sake I only included a single column name but the actual code I used included 4 columns.

Upvotes: 1

Related Questions