Two databases in one project ...

[Margaret]

Can both be open at the same time?

If not, then I would suggest using option buttons rather than checkboxes.

There are a couple of things that come to mind.

The first is to use a command button (perhaps called cmdConnect) which evaluates which checkbox/option button is selected, and issues the appropriate connect string for that database.

Thanks. Then, I would prefer command button using option buttons. Please help me with the code.

Margaret.