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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Anne" <(E-Mail Removed)> wrote in message
news:ECBB7BB2-4E4B-469B-86FB-(E-Mail Removed)...
> When I scroll through records in form view they are not displaying in
> chronological order. How do I correct this?
> --
> Anne

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

"Anne" <(E-Mail Removed)> wrote in message
news:ECBB7BB2-4E4B-469B-86FB-(E-Mail Removed)...
> When I scroll through records in form view they are not displaying in
> chronological order. How do I correct this?
> --
> 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.
--
Anne


"Jeff Boyce" wrote:

> 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
>
> "Anne" <(E-Mail Removed)> wrote in message
> news:ECBB7BB2-4E4B-469B-86FB-(E-Mail Removed)...
> > When I scroll through records in form view they are not displaying in
> > chronological order. How do I correct this?
> > --
> > Anne
>
>
>

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

"Anne" <(E-Mail Removed)> wrote in message
news:52EAFD53-1F05-4899-8F65-(E-Mail Removed)...
> 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
>
>
> "Jeff Boyce" wrote:
>
>> 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
>>
>> "Anne" <(E-Mail Removed)> wrote in message
>> news:ECBB7BB2-4E4B-469B-86FB-(E-Mail Removed)...
>> > When I scroll through records in form view they are not displaying in
>> > chronological order. How do I correct this?
>> > --
>> > Anne
>>
>>
>>

Thanks, I will put the sort on my date field.
--
Anne


"Jeff Boyce" wrote:

> 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
>
> "Anne" <(E-Mail Removed)> wrote in message
> news:52EAFD53-1F05-4899-8F65-(E-Mail Removed)...
> > 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
> >
> >
> > "Jeff Boyce" wrote:
> >
> >> 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
> >>
> >> "Anne" <(E-Mail Removed)> wrote in message
> >> news:ECBB7BB2-4E4B-469B-86FB-(E-Mail Removed)...
> >> > When I scroll through records in form view they are not displaying in
> >> > chronological order. How do I correct this?
> >> > --
> >> > Anne
> >>
> >>
> >>
>
>
>