ALl you experts...

I am trying to find a way to have a date in a cell change based on when the content in any cells in that row have changed.

As an example...
A1 = date to be changed
A2 - A10 = Various text and formulas

If any of the information in A2 - A10 changes then the date in A1 should be update automatically. This should also occur for every row.

Al

On each field's AFTER UPDATE event, just set the field in A1 to equal the function Date() if you don't need time or the function Now() if you DO need the date AND the time. For example,

Me.A1 = Date()

or

Me.A1 = Now()


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

To get this started, you can also indicate a default value for A1 in your table design as Date() or Time() as well. This will tell you when the record was created.

Usually you would have DateCreated, WhoCreated, DateModified, WhoModified fields to keep track of this info.

mmcdonal

Look it up at: http://wrox.books24x7.com