Comments

[Guest]

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!

 

[Guest]

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.

 

[Guest]

(Smiling) Yes, indeed. I discovered that the form was ordered by the
autonumbers (it is helpful to know that autonumbers are not guaranteed to be
sequential!) and I have changed the form to be ordered by entry date for the
comments so even if they enter a comment on 7/10 and change the date to 6/22
when they return to the form it will look as though they entered it on the
date listed. Thanks! Ya havta laugh with Access users or you are doomed.