All forms open when viewing form code

  • Thread starter Thread starter Jeff Oppenheim via AccessMonster.com
  • Start date Start date
J

Jeff Oppenheim via AccessMonster.com

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.

Thanks for any help.

/Jeff
 
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.
 
Thanks very much Dirk. That did the trick, and also reminds me to do better
editing management. BTY - this is access 2003


/Jeff
 
Back
Top