See a change that has not been saved

[KillMeTwice]

Is it possible to catch the event that a user has changed something in
a form when he is just switching between the windows?

The two forms have data depending on eachother and when the user makes
a change in one and click to activate the other form I want to know if
he changed something (without him saving!!). I want to avoid doing a
Refresh in the first form and a Requery in the second form if it is
not necessary!

Sincerely

Hans Kristian Eide

 

[Guest]

Hi,

Some thing like this in the Deactivate event of your form should work.

If Me.dirty = true then
'Do what you need to do here
'To save the data you could:
Me.dirty = false
End If

HTH

Rico

 

[Guest]

if you want to see a change that has not been saved then you shoudl be usign
Access Data Projects.

(which are reliable enough to always save changes when you tell it to)