module code to close a form does not work

[Angus Comber]

Hello

I have a form called NewPolicy. On this form is a button which calls some
VBA code. At the end of the code is the line:

DoCmd.Close acForm, [Forms]![NewPolicy], acSaveNo

But this line does not close the form! What am I doing wrong?

Angus

 

[Douglas J. Steele]

The Close method is looking for the name of the object to close, not a
reference to it.

Try:

DoCmd.Close acForm, "NewPolicy", acSaveNo

 

[John Vinson]

Hello

I have a form called NewPolicy. On this form is a button which calls some
VBA code. At the end of the code is the line:

DoCmd.Close acForm, [Forms]![NewPolicy], acSaveNo

But this line does not close the form! What am I doing wrong?

Angus

You're not passing the *name of the form as a text string* in the
second argument of the Close event - you're passing the Form as an
object.

Use either

DoCmd.Close acForm, "NewPolicy", acSaveNo

or (more flexibly)

DoCmd.Close acForm, Me.Name, acSaveNo


John W. Vinson[MVP]