Comments

[Cheese]

I have a table in a subform that allows for memo text or comments. There is
a date associated with this entry and the user can view all comments in a
report where the entries appear chronologically. The date field has the
default of today's date but the user can erase and enter a different
date...they frequently have to enter data days later than the event. The
comments are numbered and it was discovered that a date 6/22 was found for
entry #4 and the date 7/05 was found as entry #3. The user swore that they
have not entered it late and adjusted the date. How did this happen? Since
the report still gives the comments in chronological order, I am not
concerned but wondering how it happened?
Thanks!

 

[Jerry Whittle]

How do you determine which is entry #3 and #4? How are they numbered? If
autonumbers, they are not guarenteed to be sequential.

When dealing with users.
Rule #1: They lie.
Rule #2: When the swear that they didn't, see Rule #1.
Rule #3: When proficient at #1 and #2, they become management.