Close sub-forms in design mode before attempting to open in formview?

[Chrisso]

Hi All

Does anyone have a solution to this common MS Access development
problem?

I have a system that uses sub-forms. When I am developing I jump into
the VB editor and make a code change behind one of my subforms. The
problem then comes when I attempt to view my main form in form view
back in Access as I get this error:

"You can't open a subform when it is also open in Deisgn
view"

And sure enough when I look it seems Access has opened the subform in
deisgn mode when I made the VB change in the VB editor. This means I
have to make the code change, then come back to Access, switch to the
form and then close it manually before I can see if my code change has
worked.

This really slows down my development effort.Does anyone have any tips
of how I can speed this up. For example can you have VB close the
subform if it is in design mode before attempting to open it?

Cheers for any ideas,
Chrisso

 

[Graham Mandeno]

Hi Chrisso

I think you'll find that if you have the main form open in design view
BEFORE modifying the design (or code) of the subform, you will be able to
switch the main form from design to form view without saving the subform
code.