Close linked form with vba

[FJM]

I have 10 forms which are synchronised. When the main form is open, each of the 9 others can be individually opened using their own command button.
As each of the "non" main forms is opened, it is a filter of the main form.
Is there anyway that I can automatically CLOSE any of the "non"main forms when I go back to the main form.


I have tried deacticate, lost focus, timer etc but nothing works

[RuralGuy]

Any particular form or *all* of them? The active forms are all listed in the Forms collection.

[FJM]

Either way - if they all close it wouldn't matter
As it is access only allows a certain amount to be open at the same time anyway.....

[RuralGuy]

Did you try DoCmd.Close?

[FJM]

In order to help explain what I need, above is a screenshot of what the user sees.
The main page (called DETAILS) is a tabbed page.
On the right hand side are 11 command buttons which each open a new page. Each individual page is linked to the DETAILS page through the control NCR No.
What I would like to happen is that if the user opens any of the right hand pages, then when they have finished, any that are open will automatically close when the main form (DETAILS) is back in focus.
Is this possible

[RuralGuy]

Are the forms opened by those 11 command buttons opened in Dialog mode?

[FJM]

I am not sure how to answer this.
All forms have pop up and modal set to NO
Is that what you need to know ?

[RuralGuy]

So you do not require the user to complete the form before closing, right?

[FJM]

No - the user does not have to enter anything on any of these forms - they are for viewing only.
There is a duplicate set of the forms whcih are used for data entry purposes and these are opened via another switchboard form

[RuralGuy]

So once the user leaves the additional form they are assumed to be done viewing it? What did you put in the various events of that form to try and close it?

[FJM]

I looked on several sites and forums and tried DoCmd code on the following events
Deactivate
Lost Focus
On Timer
none have worked - but that is probably down to inaccurate use of code
I need to understand whether what I want is dooable and if I am actually going abouit it the right way.
If I am on the right path I think it is then simply a matter of finding out which event will work best.................

[RuralGuy]

See if you can display a MsgBox in those events. Then you'll know if they are firing. The message should say which event they are in.

[RuralGuy]

I believe it would be better for each form to close itself but here's a link to code that would close them all. It is also a terrific site as a reference for darn near anything.
http://access.mvps.org/access/forms/frm0040.htm