Hello Jim!
Tuesday December 10 1996 10:08, Jim Chevraux wrote to Cindy Cheek:
 CC>> The 2nd date will be a changing date but will change only when
 CC>> that record is edited; the edited date. (hopefully entered
 CC>> automatically).
 JC>         Anyways, what you could do is add a routine into the On Change
 JC>  property for each field that can be edited that simply replaces that
 JC> field with the current date.  For example, if you had a [PaidOn] field
 JC> and the field you wanted to contain the last modified date was called
 JC> [Modified] , the On Change property for the [PaidOn] text box would
 JC> look like this:
 JC>         Private Sub PaidOn_Change()
 JC>           Modified = Date
 JC>         End Sub
Huh?  Beg your pardon?  I'm not sure I follow.  Does this mean I have to 
write a macro to reflect an event change?  If so, I'm not sure I know how to 
do this since there's not a macro option of this nature to choose from.  
Gosh, I think need a refresher ACCESS class...ugh
I had a couple of other responses, similar, but I think they need a macro 
too. I'll work on it and see what I can do.  Thanks for your input.
Cindy
--- Hertzian Mail+
---------------