Re: "docmd.close..." a doubt

The "save" associated with DoCmd.Close has no impact on the record. It is
the form itself that is/is not saved - properties such as its Filter and
OrderBy.

To discard the record and close the form, undo it:
If Me.Dirty Then
Me.Undo
End If
DoCmd.Close acForm, Me.name

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"rocco" <(E-Mail Removed)> wrote in message
news:48D86DA0-4486-4F01-8E09-(E-Mail Removed)...
> Hello,
> i ahve a doubt.
> it seems to me that the two lines:
> - docmd acform, formname, saveno
> - docmd acform, formname, saveyes
> both save data in table while i thought that the first one just close the
form without saving data in th table.
> Is this true?
>
> thanks,
>
> Rocco