Newbie: How to set up a combo box to work on an Access table? 1

[RikHess]

I moving some Access apps to VB and ran into a problem with a lookup combo box. The table I'm using will contain a list of active tables in the database. No problem building the table at Form Load, but the Combobox will not read the file contents.

I have tried : cboTableNames.Refresh
after re-building the contents.

I have linked the Combobox using the DataSource, DataMember, and DataField properties, to no avail.

Any ideas are appreciated.

TIA,
Rik

 

[Overdoos]

I don't know if you can do this with the 'Data' properties.

This is the way I do things:

* open a connection to the DB
* run a query returning the values you want to add to the combobox in a recordset
*

 Do Until <recordset>.EOF
   <combobox>.additem <recordset>!<field>
   <recordset>.MoveNext
  Loop

* close the recordset and the db-connection

I'd be happy to help you further along with some sort of function if you can be a bit more specific on what you are looking for...

 

[RikHess]

That was easier than I was trying to make it!

Thanks!
Rik