Check ODBC connection when opening form

[accessnewbie]

This is my 3rd post this year, I think I need to talk my boss into signing me up for classes!

I have a button on a form (FormA) that opens another form (FormB). In FormB is a list box that displays results from a query using a linked database table, so when FormB opens, I'm asked to connect to the database. As long as I log in correctly, FormB looks fine. I just tried to log in using an old password and FormB opened, but the list box was empty. I would like to display an error message should this happen, but am at a loss at where to put it and what code to use.

Thanks for any help.

Thanks,
Marisa

[TheShabz]

You have to log in every time you open the form?

Try to get a system or user DSN for your ODBC connection set up on your machine. Then when you link tables, you login once and check "save password" when selecting the tables to link to. Never login again.