Closing opening menu after selection made.

[Charlie]

Hello,
I have created a database in Access 2002 which on opening starts up a menu form containing buttons linking to the other forms in the database.

I have a macro setup on each form to maximize the size on opening, my problem is I want the previous form the menu to close when the menu item is selected upon the clicking of the relevant selection button.

I would also like the menu to re-open on the closing of the selected menu item.

How can this be achieved?


Cheers Charlie

 

[Dugantrain]

Write a function or sub and then call that in the on-click event of every button that opens a form:

Command1_OnClick()
'Code to open another form here
Call Close_Function
End Sub

Command2_OnClick()
'Code to open another form here
Call Close_Function
End Sub

Command3_OnClick()
'Code to open another form here
Call Close_Function
End Sub


Public Function Close_Function
Docmd.Close acForm, "Your_Form_To_Close"
End Function

 

[Charlie]

Thanks Mate,
That's half of it working now, how do I get the menu to reappear on the closing of the form?


Charlie

Ahh sussed it...Thanks again.