Problem closing a form.

[JB510]

I have a bunch of code to update Excel, send email, update records etc ..


At the end I give the command

DoCmd.Close ObjectType:=acForm, ObjectName:="Build1F"
DoCmd.OpenForm "MainMenuF"

To close the form and open the main menu.

I am getting an error "This action can't be carried out while processing a form or report event."

There are no other forms open and I am not calling up more than the subroutine it is running in.
How do I get around this?

(It is working in other forms)

[pbaldy]

Two shots in the dark. Add DoEvents between the lines or reverse the order of your two lines.

[JB510]

Two shots in the dark. Add DoEvents between the lines or reverse the order of your two lines.

Tried reversing.. it will process the

DoCmd.OpenForm "MainMenuF"

but the

DoCmd.Close ObjectType:=acForm, ObjectName:="Build1F"

it don't like. - Same error

[Welshgasman]

I think you might need to show the code before it?
Quick trst would be comment out all code before those two lines and see if that works.
Do the easy stuff first.

[JB510]

Sorry for the delay but thank you.
Issue solved.
I commented all the code out and it still failed to close..
Problem was the command

DoCmd.Close ObjectType:=acForm, ObjectName:="Build1F

did not work..

I replaced it with

DoCmd.Close

Totally frustrating....

[Minty]

The most reliable way to close the current form (and not some other arbitrary object) is

  DoCmd.Close acForm, Me.Name

This uses the current forms name, so can't really go wrong.

[JB510]

My apologies'... it was because the close command was in a

xxxxx_LostFocus ()

event.

It did not like it. I had to change it to a

xxxxxx_AfterUpdate()

event.

[pbaldy]

That makes more sense, thanks for the update. I typically use Minty's method too.