Filling combobox with data from another database

[ReidarT]

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

 

[Allen Browne]

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';