Combo box with values taken from another database

[Etrom]

Hi guys,
I'd like to create a combo-box in a database which takes its values from a field in a table in another db. Both of the dbs are on my computer.
How can I do that?

 

[pr2-eugin]

Try something along the lines of.. Using the IN Clause..

SELECT someFields FROM theTable
[COLOR=Red][B]IN[/B][/COLOR] "C:\FullPath\ofTheDB.mdb";

 

[rzw0wr]

I would link the table from the other database.
It can also be done with code.

Dale

 

[Etrom]

Great eugine, I think it should work.

I would link the table from the other database.
It can also be done with code.

Dale

By the way, rzw0wr, how can I link a table from another database?

 

[rzw0wr]

The same way you link to a back end.
External Data tab/Access/Browse
Find your file/Click open/Select Link tot the data source and click OK.

Dale

 

[Etrom]

Understood, thank you very much

 

[rzw0wr]

Side note here, the linked table does not have to be related to the other tables in the database.
It would be nice if it were but does not HAVE to be.

Dale