Hi there,
  I am working on a form which contains a sub-form. In the sub-form, there are two fields which can be edited by the users and when either of them is updated, I need to change the last_update field in the table. What is the best way to do this?

Any help would be appreciated.

Best Regards,
Arholly

And just for clarification, one of the two fields users can update is a checkbox, the other is a drop down.

Use the Before Update event of the form.

Me.last_update = Date()



mmcdonal

Now that will not update the form if there are no changes, right?

That will ONLY update the record source IF there is an Update made to the data, which is what you are looking for.


mmcdonal