Displaying records in form view

A

Anne

When I scroll through records in form view they are not displaying in
chronological order. How do I correct this?
 
D

Douglas J. Steele

Create a query that sorts your data chronologically, and use that query as
the RecordSource of your form.
 
J

Jeff Boyce

Anne

Unless you tell Access what sort order to use, Access gets to decide.

A common solution is to use a query to return the fields you want displayed
in the form, based the form on the query, and put your sort order into the
query (i.e., sort on the date/time field for "chronological order").

?If your underlying table has no date/time field, how will Access "know" the
chronological order?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

Anne

Thanks Jeff,

I already had a query so I have added a sort order to the WorkorderID field
in the Work Order table. This is the key field in the table so now I hope
they will display in the order that they are created, which is what I was
aming for. I think the date field wouldn't have been so good because we
create my work orders on any given day so they may not have displayed as I
wanted. Looks okay at the moment but sometimes is was and sometimes it wasn't
before I added this control so I will wait and see. I guess that was a case
of Access making up its own mind. Thanks again.
 
J

Jeff Boyce

Anne

If you are saying you have an Autonumber field (for WorkorderID), it may not
always be sequential. Autonumbers are intended for use as a unique row
identifier, nothing else.

You would be better served by including a Date/Time field to which you write
the value of the current moment in time (hint: use Now()) when the record
gets created. Then sort on that.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top