G
Guest
Hi!,
please help me how to stop saving record on close of exit of my form.
thanks
KRISH
please help me how to stop saving record on close of exit of my form.
thanks
KRISH
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Cancel the BeforeUpdate event of the *form*.
That's the only way to catch it before the record is saved, regardless of
how that is triggered, e.g. closing the form, applying a filter, changing
the sort order, moving to another record, closing Access, reassigning
RecordSource, pressing Shift+Enter, saving through the menu, etc, etc.
That's the only way to catch it before the record is saved, regardless of
how that is triggered, e.g. closing the form, applying a filter, changing
the sort order, moving to another record, closing Access, reassigning
RecordSource, pressing Shift+Enter, saving through the menu, etc, etc.