Date Modified problem
I have my database set up with a Date Created field and a Date Modified field for each record. The problem is every time I open the database, the date modified field automatically updates to the current date, before I have modified anything. I figure it is probably because of one of the calculation fields (of which there are many). Is there any way to only have the Date Modified field change only when an entry field is physically changed?
The calculation fields shouldn't change unless something that they reference also changes. Do you have a start up script that performs when the file opens or a script performed by an On LayoutEnter trigger? Might they be modifying the record in some way?