modified date field

[ljg08]

Hi Guys,

I have a table that has field [modified], which is a date field, can anyone
tell me how I get this to update when details of the record are changed, are
thier any default settings I can apply to this field to update when the
records value is changed, other than an update query?

TIA

 

[KARL DEWEY]

Not doing it in the table. Anyway you should use a form to add and edit
records.
You can have an Event on your form - 'On Change' or 'After Update' to Set
Value using Now() to capture the modification DateTime.

 

[ljg08]

Cheers Karl,

Thats the answer, many thanks

Not doing it in the table. Anyway you should use a form to add and edit
records.
You can have an Event on your form - 'On Change' or 'After Update' to Set
Value using Now() to capture the modification DateTime.
--
KARL DEWEY
Build a little - Test a little

Hi Guys,

I have a table that has field [modified], which is a date field, can
anyone
tell me how I get this to update when details of the record are changed,
are
thier any default settings I can apply to this field to update when the
records value is changed, other than an update query?

TIA