close Form from within a Form.current event

[alextijuca]

The following statement doesn't work within a Form.current event:
DoCmd.Close acForm, Me.Name, acSaveYes


What could I do to achieve this action ?

Thank you in advance

[June7]

Why would you want to close a form from its Current event?

What does "doesn't work" mean - error message, wrong results, nothing?

What is the complete procedure code?

[John_G]

In Access 2010, you can't close a form while you are running a form-level event (you get an error message), and On Current is a form-level event.

I assume A2000 is the same.

Tell us what you are trying to do, so we can offer some suggestions.

[June7]

Open event has argument to allow canceling form open. That is probably the only place form can be 'closed' at form level - if condition is met the form doesn't open, user doesn't even see it.

[alextijuca]

As John_G said, I get an error message saying operation is not possible.
I have a number of registers that I can create and, when that finishes, I have to come out of the form.current event back to the initial form. So my first thought was to write a command that did that.

I will try the Open event suggested by June 7 and see what happens. In the event, I will display a message to the user saying he cannot create more registers.

Any other suggestion will be welcomed.

Thank you all.

[June7]

How will code in Open event help you get 'back to the initial form' after data entry is completed? Form can be closed by code in button Click or a control AfterUpdate events.

[alextijuca]

Hi,

I have noticed that I can come out from the form by writing a docmd.close instruction in the Form.Open event, by testing a condition. However, the flow of the program moves to the Form.current event before closing the form. I expected that it would just finish the present event (Form.Open) e return to the previous Form.

Does anyone know a command for not passing through the Form.corrent event as above described ?

Thank you

[John_G]

Instead uf using Docmd.close, cancel the On open event by setting Cancel = -1

if your test condition fails.