I have a form with a few command buttons. These command buttons open forms.
In the OnActivate event of the main form I put in the line
msgbox "Activate"
When I press a button to open a form, close the opened form, I get the
message "Activate"...except for one. All of the called forms have the
syntax
Docmd.Openform "FormName"
with no arguments.
All opened forms are closed with
Docme.Close acForm, "CurrentFormName"
Is there any reason you can think of that the one form, when closed,
does not "activate" the main form? The only difference between it and
the other forms is that it is unbound and has 2 subforms in it. The
others are forms are unbound with a datasheet subform inside it.