Filling combobox with data from another database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ReidarT - 30 Apr 2005 11:30 GMT

I want to fill a combobox with records from a table in another database (the
table is not active (nor local or linked) in this front-end database)
I can open the database and get the recordset, but I don't know how to bind
the combobox to the recordset.
regards
reidarT

Reply to this Message

Allen Browne - 30 Apr 2005 12:39 GMT

It might be easiest to link the table, but you could set the combos
RowSource to something like this:
SELECT MyId FROM MyTable IN 'C:\MyFile.mdb';

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I want to fill a combobox with records from a table in another database
>(the table is not active (nor local or linked) in this front-end database)
> I can open the database and get the recordset, but I don't know how to
> bind the combobox to the recordset.
> regards
> reidarT

Reply to this Message