I'm trying to learn Access and VBA at the same time. I purchased the Access 2007 VBA book. In chapter 6 there is examples of building a switchboard for using multiple forms. I wrote the code and it all worked great until I closed Access and then reopened it. Now my command buttons do not work. Any ideas why?

Well, what does happen?

I suspect that you added the buttons, saved the form, added the code on the button clicks, tested it (it worked), then you closed the app without further saving. If so, the button additions were saved, but not the code additions.

Possibly you may also have changed the name of the buttons (not as likely an explanation as not saving but possible) and the code that is tied to the name of the original buttons simply isn't being executed.

Gordon