Save record on lost focus

[randria]

Hi,

In a countinuous form, I have 2 controls ctrA and ctrB that make up a set of
records. I have control ctrC on the form footer counting the records if ctrA
has a value regardless of the ctrB's value.
ctrC counts the records only after the user moved to the next line or to
another set of record. So in a situation where the user deletes ctrA's value,
and straight away close the form, ctrC will have an incorrect count. so I m
wondering if it is possible to save the record on ctrA lost focus. Or
stopping the form to close so that the user can to a different record/next
line ( although I dont really like this ) before closing.
Many thanks.

 

[Beetle]

Try;

If Me.Dirty Then Me.Dirty = False

In the Close event

 

[randria]

Hi Beetle,

Many thanks for your advice, I put the code On change and it works
perfectly. Many thanks.

 

[John W. Vinson]

On Fri, 12 Dec 2008 22:22:01 -0800, randria

He did NOT specify the change event - and that event fires *with every
keystroke*, so it's not the appropriate event in any case.

I'd use the AfterUpdate event myself, but many events will work.