Closing a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 28 May 2008 21:28 GMT

I am creating an application where I want Form A to call Form B, then have
Form A close. Does anyone know how to do this? Thank you.

Reply to this Message

Klatuu - 28 May 2008 22:26 GMT

'Open Form B
Docmd.OpenForm "FormB"
'Close Form A
Docmd.Close acForm, Me.Name, acSaveNo

Signature

Dave Hargis, Microsoft Access MVP

> I am creating an application where I want Form A to call Form B, then have
> Form A close. Does anyone know how to do this? Thank you.

Reply to this Message

Jim - 29 May 2008 13:52 GMT

When I tried this, I received an error 2585 (This action can't be carried out
while processing a form or report event). Any other ideas? Thanks.

> 'Open Form B
> Docmd.OpenForm "FormB"
[quoted text clipped - 3 lines]
> > I am creating an application where I want Form A to call Form B, then have
> > Form A close. Does anyone know how to do this? Thank you.

Reply to this Message

Klatuu - 29 May 2008 15:15 GMT

Where are you trying to execute this code?
Try reversing the order to:

Docmd.Close acForm, Me.Name, acSaveNo
Docmd.OpenForm "FormB"

Signature

Dave Hargis, Microsoft Access MVP

> When I tried this, I received an error 2585 (This action can't be carried out
> while processing a form or report event). Any other ideas? Thanks.
[quoted text clipped - 6 lines]
> > > I am creating an application where I want Form A to call Form B, then have
> > > Form A close. Does anyone know how to do this? Thank you.

Reply to this Message