open another database from my form

[paulevans]

Hi

Is it possible to open a second access database from a from.

I.e I create an application menu in a master database and then from this I call smaller databases.

for example

I would have a master db called contracts this opens a menu form. From the menu I may select sub-contracts that opens the database subcontracts.

is this possible and what sort of code would I need?