Jeff Oppenheim via AccessMonster.com said:
I want to view the code on one form but when I select View > Code
from the tool bar, every form opens to "View" code. Is there a way
to prevent this from happening. Hopefully this is fairly clear.
(Note: if you're using Access 97, the following advice doesn't apply --
but that would mean something really odd is going on.)
While in the VB Editor (viewing code), close all the individual module
windows, one by one, except for one. Leave one module window open. In
that module, type a space or two at the end of a line. That will make a
"non-change" change. Now close that module window, then click the Save
button on the toolbar. Close the database and reopen it, and you should
find when you go to the VB Editor that all the module windows remain
closed.
To keep from getting cluttered up like that again, close module windows
when you edit them, before you click the save button.