Close Form on 'Deactivate' Event

[DerickD]

Hi All,

I want to close a form as soon as it is deactivated.

So I place :

DoCmd.Close acForm, "frm_MoveToStep"

on the 'Deactivate' event. It brings back the error "This action can't be carried out while processing a form report event"

Am I doing something wrong? What is the correct / best way of doing this.

Or is there a way of doing this.

Thanks again for all the Tek-Tips help.
DerickD

 

[DerickD]

Maybe more information will help :

On Form1, I have a button that opens Form2.

Form2 is smaller than Form1 so the user has the tendancy to switch between the two...

What I want to do is as soon as the user switches between Form2 and Form1, Form2 forcfully closes, so to get back to Form2 the user 'has'to press 'Open Form2' Button.

What is the best way of doing this?

Thanks
again all.....
Derickd