See a change that has not been saved

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KillMeTwice - 23 May 2007 10:48 GMT

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

Reply to this Message

rico - 23 May 2007 13:06 GMT

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

> Is it possible to catch the event that a user has changed something in
> a form when he is just switching between the windows?
[quoted text clipped - 8 lines]
>
> Hans Kristian Eide

Reply to this Message

aaac@aaac.org - 25 Jun 2007 05:07 GMT

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)

> Is it possible to catch the event that a user has changed something in
> a form when he is just switching between the windows?
[quoted text clipped - 8 lines]
>
> Hans Kristian Eide

Reply to this Message