-=> Quoting Cindy Cheek to All <=-
 CC> The first date will appear once and stay unchanged forever; 
 CC> the created date.
        Set the "Default Value" of the field in the table or form to Date() 
and whenever you open a new record, it'll fill in the current date 
automatically.  You can optionally set the Locked property for that text box 
on the form to No, which will prevent anyone from being able to edit that 
field (in which case, I'd also set Tab Stop for that text box to No).
 CC> The 2nd date will be a changing date but will change only when that 
 CC> record is edited; the edited date. (hopefully entered automatically).
        I've never found a really good way to do this, so perhaps someone 
else 
will mention something easier to do than this, but here's one way to do it:
        Anyways, what you could do is add a routine into the On Change 
property for each field that can be edited that simply replaces that field 
with the current date.  For example, if you had a [PaidOn] field and the 
field 
you wanted to contain the last modified date was called [Modified] , the On 
Change property for the [PaidOn] text box would look like this:
        Private Sub PaidOn_Change()
          Modified = Date
        End Sub
jc
 
... Dogs crawl under gates, software crawls under Windows.
--- FLAME v1.1
---------------