Close current form on deactivate?

[sasolini]

Hey,

Can someone pls tell me how to close a form as soon as it gets deactivate? Becouse i try with Docmd.Close but it tells me that i can not do that in this event, but thats exactly what i would like to do - close form when it gets deactivated?

Thx

 

[ghudson]

That does not make sense to do that.

In a command button OnClick event [or something else] you can call this code to close the form.

DoCmd.Close acForm, Me.Name

 

[sasolini]

I know i can do that with a command button, but i dont want that...And it make sense, becouse i dont want users haveing two or more forms open.

 

[ansentry]

How can your users have 2 or more forms opened?

If you have a menu system, a user clicks a command button to open a form and then clicks a command button to close the form and either return to the main menu or another form.

I agree with ghudson use command buttons.

 

[ghudson]

In the OcClick event of your button to open the other form you need to also close the current form. This will do that...

    DoCmd.OpenForm "frmForm2"
    DoCmd.Close acForm, Me.Name