Dates are shuffled

I work with a large and rather complex database which is used by a number of
organisations. I didn't make it and some its workings are a mystery to me.
Sometimes very odd things happen. For example, there are a number of
different 'forms' in it. One of them requires the user to enter various bits
of information starting with a date. Many records will be entered and the
user can scroll back and forth between them using the standard scroll bar
with the arrows etc.

Normally all the records are in date order but some users (not all)
experience a situation where all the records are shuffled up and not in date
order! What could be the problem here?

There are different possibilities. How are the records being displayed? On a
form, in a listbox or what? How is the form or listbox loaded, via a query, a
table or in VB code? You need to check if the dates are indeed being sorted
or if its just a happy accident that they are mostly in order.

Dorian

"C Tate" wrote:

I work with a large and rather complex database which is used by a number of
organisations. I didn't make it and some its workings are a mystery to me.
Sometimes very odd things happen. For example, there are a number of
different 'forms' in it. One of them requires the user to enter various bits
of information starting with a date. Many records will be entered and the
user can scroll back and forth between them using the standard scroll bar
with the arrows etc.

Normally all the records are in date order but some users (not all)
experience a situation where all the records are shuffled up and not in date
order! What could be the problem here?

Hmmm, well the records are displayed on a form but I'm not sure how the form
is loaded. It's a table I think.
"mscertified" wrote in message
...
There are different possibilities. How are the records being displayed? On
a
form, in a listbox or what? How is the form or listbox loaded, via a
query, a
table or in VB code? You need to check if the dates are indeed being
sorted
or if its just a happy accident that they are mostly in order.

Dorian

"C Tate" wrote:

I work with a large and rather complex database which is used by a number
of
organisations. I didn't make it and some its workings are a mystery to
me.
Sometimes very odd things happen. For example, there are a number of
different 'forms' in it. One of them requires the user to enter various
bits
of information starting with a date. Many records will be entered and the
user can scroll back and forth between them using the standard scroll bar
with the arrows etc.

Normally all the records are in date order but some users (not all)
experience a situation where all the records are shuffled up and not in
date
order! What could be the problem here?

In the form designer, Click 'View--Properties' then click the Data tab and
look at 'Record Source' and 'Order By'. If it's a table, the records are
unsorted unless there is something in 'order by'. If it's a query, you will
have to look at the query to see if it is sorting (has an ORDER BY clause).

Dorian

"C Tate" wrote:

Hmmm, well the records are displayed on a form but I'm not sure how the form
is loaded. It's a table I think.
"mscertified" wrote in message
...
There are different possibilities. How are the records being displayed? On
a
form, in a listbox or what? How is the form or listbox loaded, via a
query, a
table or in VB code? You need to check if the dates are indeed being
sorted
or if its just a happy accident that they are mostly in order.

Dorian

"C Tate" wrote:

I work with a large and rather complex database which is used by a number
of
organisations. I didn't make it and some its workings are a mystery to
me.
Sometimes very odd things happen. For example, there are a number of
different 'forms' in it. One of them requires the user to enter various
bits
of information starting with a date. Many records will be entered and the
user can scroll back and forth between them using the standard scroll bar
with the arrows etc.

Normally all the records are in date order but some users (not all)
experience a situation where all the records are shuffled up and not in
date
order! What could be the problem here?