Sorting of data in a subform

[KarenF]

Hi,

A colleague of mine has a contacts database and uses a subform to type any
relevant comments about any communication with that contact with the date of
that communication in a separate field. When there is more than one
communication within any day it is entered as a separate record. In Access
2003, the subform records were sorted by date and then appeared to be in the
order in which they were entered. Now, using 2007 (the database hasn't been
converted yet), the subrecords appear in date order but not in conversation
order. So, if 3 separate communications are entered for 12 October 2009,
they are shown together as the form appears by date, but, they are then
sorted alphabetically by what is typed in the communication comments field.
Other than preceeding each comment with either a consecutive number or
letter, or adding a date and time stamp field, is there another way to sort
this out?

My colleague is frustrated as it worked fine in Access 2003. Other than
what I've mentioned I'm not sure how to help her. Any ideas would be
gratefully received.

Thanks very much.

Karen

 

[John W. Vinson]

Hi,

A colleague of mine has a contacts database and uses a subform to type any
relevant comments about any communication with that contact with the date of
that communication in a separate field. When there is more than one
communication within any day it is entered as a separate record. In Access
2003, the subform records were sorted by date and then appeared to be in the
order in which they were entered. Now, using 2007 (the database hasn't been
converted yet), the subrecords appear in date order but not in conversation
order. So, if 3 separate communications are entered for 12 October 2009,
they are shown together as the form appears by date, but, they are then
sorted alphabetically by what is typed in the communication comments field.
Other than preceeding each comment with either a consecutive number or
letter, or adding a date and time stamp field, is there another way to sort
this out?

My colleague is frustrated as it worked fine in Access 2003. Other than
what I've mentioned I'm not sure how to help her. Any ideas would be
gratefully received.

Thanks very much.

Karen

What's the Recordsource properety of the subform (post the SQL)? What's the
DefaultValue property of the date field: if it's Date() then each record will
get just the date, if it were Now() then it would get the date and time, which
would sort correctly (but might cause other issues since the Date/Time field
would contain both the date and the time).

 

[KARL DEWEY]

Why not use Now() for the default of communications date to get the sort but
set format of the form text box to short date to omit the time?