Here's my problem: I would like to 4

[kevinwilson]

Here's my problem:
I would like to have the "ModifyDate" field in my table updated every time the recordset is changed.

For example:
Before
recordset1
Bldg Room Description ModifyDate
AA 101 Projector 06/10/2001

After
recordset1
Bldg Room Description ModifyDate
BB 202 Projector 07/19/2001

On my forms, where I'm able to change Bldg and Room information, I would like the ModifyDate field auto updated when any change is made to the recordset. I've tried the "After Update" control in the properties dialog without success. (heh)

Any help would be greatly appreciated!

Aloha,
~kevin

 

[JoeMiller]

I do this kind of thing all the time by using this command in the BeforeUpdate event.

If Me.Dirty = True Then
ModifyDate = Date()
End If

HTH
Joe Miller
joe.miller@flotech.net