My table X has a field DateLastUpdated, along with 7 other fields.
Within my Form, I wish to set this field to todays date whenever any of the 7 others change.
To do this, I suspect I can set an On Change[Event Procedure] for each of the 7, but is there a better way of doing this ?
And can you suggest what the vb coding might be, as I am a complete novice.
This field should also be set when a new record is written to table X.
Many thanks
Within my Form, I wish to set this field to todays date whenever any of the 7 others change.
To do this, I suspect I can set an On Change[Event Procedure] for each of the 7, but is there a better way of doing this ?
And can you suggest what the vb coding might be, as I am a complete novice.
This field should also be set when a new record is written to table X.
Many thanks