Changes in a form

[Danielf]

I have a form based on a table.
I am looking for a function showing that
the values of the fields in the form have been updated.
( for example : changes have been made in the form =true,
if nothing has been updated in the form =false)

Thanks for help.

Daniel

 

[Pat Hartman]

Are you trying to determine if someone has just changed the data or if the data was changed some time in the past?

If the former, you can put whatever code you want to execute in the BeforeUpdate event of the Form. This event is only executed if some change was made to the current record and it is the last event executed before the record is actually saved.

If the later, you need to add a date/time field to the table and populate it whenever the record is changed. This won't tell you what was changed, only that something was changed. An audit trail is necessary if you need to identify what was changed.

 

[Danielf]

Hi Pat,

I have a found a solution:
when the data in the form is changing,
I set a variable to "TRUE";So I know, if
something has changed in my form.

Thanks

Daniel