Displaying records in form view

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

When I scroll through records in form view they are not displaying in
chronological order. How do I correct this?
 
Create a query that sorts your data chronologically, and use that query as
the RecordSource of your form.
 
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
 
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.
 
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
 
Back
Top