I have a table with 3 fields that I need to work on [StartDate], [EndDate], [ChangeDate]. What I'm wanting to do is whenever I make a change to either [StartDate] or [EndDate], I want [ChangeDate] to get the latest date. Is there a way to do this?
I have a table with 3 fields that I need to work on [StartDate], [EndDate], [ChangeDate]. What I'm wanting to do is whenever I make a change to either [StartDate] or [EndDate], I want [ChangeDate] to get the latest date. Is there a way to do this?
Code:sub StartDate_Afterupdate() ChangeDate =date end sub sub EndDate_Afterupdate() ChangeDate =date end sub
Worked perfectly. You're awesome. Thanks.