ComboBox in VB from Access DB

[JuanMellado]

Hi Guys

Im working with Excel, VB and Access, and now I want to show a table from access in a ComboBox, but I cannot get it, Im using recordset but i can't,

Somebody know how can I show the table in the ComboBox as list.

Thanks

 

[genomon]

As far as I know you cannot show "a table", but you can show its fields in a CBO.

Beir bua agus beannacht!

 

[SkipVought]

Hi,

Simplest way: Import your Access table via Data > Get external data > From Access... And drill down to your db. Your table will end up in a worksheet, top-left cell of table where you started this process. I'd start in A1. You only need to perform this process ONE TIME. You can Refresh Data to return a current snapshot of the table.

This process creates a Structured Table, a very useful feature in Excel. Use Excel HELP to discover the features. You can use these features to link the data you need to your CBO and keep the link reference always up to data.



Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]