Hi,

I have created a new form that reads in data from some intermediate tables.
These intermediate tables are used to compile data for use in a report or
the new form I have made.

Having opened the new form with this intermediate data (it provides an
aggregate view of various top-level codes in column A) the user can view and
add projections.

The user can close the form and then make changes in the database.  At this
point I know if the form is reopened then my code will repopulate column A
with the updated figures.

Is there a way of determining if the data has changed before I run that
code?  That way I can avoid running the repopulation code.  And if it's
changed I can display a message to the user.  I can think of a number of
clunky ways of doing it but would like alternate opinions.  Obviously I'm
looking for a general sort of solution as I have quite a few tables that
could be changed.  I wish there was some sort of built-in global flag that
could track this sort of thing, would make it alot easier.

thanks
Martin