Close or unload a form 1

[leonepaolo]

Hi!

I can't figure out how to close and/or unload the current form. Essentially, once the user has pressed a command button and the code is executed, there is no further use for the form and I would like that form to close automatically.

Any comments or suggestions are appreciated.

Thanks in advance,
Paolo.

 

[Remou]

How about, at the end of your code:
DoCmd.Close acForm, "frmFormName

 

[leonepaolo]

Hi Remou,

That doesn't want to work for me.

I've also tried:
DoCmd.Close acForm, "frmFormName", acSaveYes
DoCmd.Close acForm, Me, acSaveYes

Could I be missing a reference? Any other thoughts?

Thanks for your help,
Paolo

 

[Remou]

How about
DoCmd.Close acForm, Me.Name, acSaveYes

 

[leonepaolo]

Beautiful,

Thanks a bunch.