Hi,

Does anyone now how to check if a form is open and close it from another form?;)

Tim

__________________
Tim

The acSaveYes saves any data before closing the form.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I am having a problem using DoCmd.Close

I have a form that checks to see if the data being entered is being entered into the correct form.

If the data being entered into Form1 is supposed to be entered into Form2, I want to close Form1 and open Form2.

I'm using
DoCmd.OpenForm "Form2"
in the module of Form1 to open Form2.

Then in the Open event of the Form2 I'm using
DoCmd.Close acForm, "Form1", acSaveNo
to try and close Form1.

My problem is, I can get Form2 to open, but I can't get Form1 to close.

Any suggestions?

See if the order in which you do it is important. Try closing Form1 before opening Form2. Some weird system stuff may be happening because Form1 may be open but doesn't have the focus to close. Sounds funny, but you know Access...


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

What I would suggest is just put both actions in Form1's event, i.e. Open Form1, then close Form2 all from the same procedure, such as:

Sub OpenOtherForm
DoCmd.OpenForm "Form2"
DoCmd.Close acForm, "Form1", acSaveNo
End Sub

Which would be in Form1's module

Steven

I am a loud man with a very large hat. This means I am in charge

You stated that if the data was supposed to be in Form2 and they were entering it in Form1, then Form1 is supposed to close and Form2 open. Are you transferring the data values that they may have already entered in Form1 to Form2? If so, then you probably need to tell Form1 to open Form2, then in Form2 onActivate event tell Form1 achidden, then when you close Form2, it take you back to Form1 acNormal (or close both).

Regards,

Beth M