Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
After record is modified in ANY field...
- Thread starter Vol
- Start date
HI
try
after update event for each field call a sub function
sub function SetDateModified
Me.YourDateField = Date
end sub
here any field that is modified will call the sub function this will in turn set the date modified field to date.
you could get a little more complicated and use the form before update and check the "dirty" property for the current record and set the date this way
HTH
Robert Dwyer
rdwyer@orion-online.com.au
try
after update event for each field call a sub function
sub function SetDateModified
Me.YourDateField = Date
end sub
here any field that is modified will call the sub function this will in turn set the date modified field to date.
you could get a little more complicated and use the form before update and check the "dirty" property for the current record and set the date this way
HTH
Robert Dwyer
rdwyer@orion-online.com.au
- Status
Similar threads
- Question
