a2k - simple way of detecting data changes in app

[Deano]

In my app I have lots of forms with data presented in various ways
using all kinds of controls.

Is there a simple way of detecting if the user has changed any data? I
would like to do this so I could set a boolean value to True and then I
could use that to modify what is displayed on my reports.

In my dim memory is there a dirty property for forms that would do
this? Would that always work for every form? Most, if not all, of my
forms are bound to tables and queries.

thanks
Martin

[Ed Robichaud]

The On Dirty form property fires when there is any activity on the form; the
On Change event fires when a control's value has been changed. A common
solution is to create a date/time field in your underlying table, then on
the data entry form's Before Update event, put:
Me!myUpdateFiel d = Now()
This will record a new date/time when any value on the form has been
changed.

Not sure how you're running your reports, but they will always have the
current values of the bound recordset. Do you really want to reprint
reports every time there is a data change?
-Ed

"Deano" <ma**********@g mail.com> wrote in message
news:xn******** *******@usenet. plus.net...

In my app I have lots of forms with data presented in various ways
using all kinds of controls.

Is there a simple way of detecting if the user has changed any data? I
would like to do this so I could set a boolean value to True and then I
could use that to modify what is displayed on my reports.

In my dim memory is there a dirty property for forms that would do
this? Would that always work for every form? Most, if not all, of my
forms are bound to tables and queries.

thanks
Martin

[Deano]

Ed Robichaud wrote:

The On Dirty form property fires when there is any activity on the
form; the On Change event fires when a control's value has been
changed. A common solution is to create a date/time field in your
underlying table, then on the data entry form's Before Update event,
put: Me!myUpdateFiel d = Now()
This will record a new date/time when any value on the form has been
changed.

Not sure how you're running your reports, but they will always have
the current values of the bound recordset. Do you really want to
reprint reports every time there is a data change?
-Ed

Thanks for the tip. It's not that but I have a label that shows the
last backed up data. If they make a change without explicitly creating
a new backup then I don't want that label to be printed as it will be
misleading.