Scrolling form order

[RustyRick]

I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number".

Why is that?

 

[WSanchez]

Check Form Properties. Under the Data tab is the row "Order By". Employee is likely entered there which you can clear out. If this is the case it could have just been changed by someone clicking one of the sort buttons in the ribbon.

 

[RustyRick]

Order is blank
Order by on Load is - YES

Changing that to NO, doesn't help.

Still stuck

 

[WSanchez]

Well, you can use that "Order By" field to have the form sort by your liking. Or maybe you want to add the field to the Record Source and sort by that?

Your question of why I can't answer. I have the same experience and just solve it by the screen capture I have attached.

 

[RustyRick]

So does Access arbitrarily decide which field it's going to sort by if left to it's own recognisance? Or have I got a setting telling the form in what order to display the "Next Record" goto?

 

[WSanchez]

What is the latest table that you added to your form?

 

[CJ_London]

If you don't order the data then Access will typically order by the order in which each record was entered into the table so set the order by [Record Number] either in the form as indicated previously or in your form recordsource

 

[WSanchez]

I don't know. I have a form that is based on one table that has a primary key that is a text field. Without anything being declared the form is sorting by the primary key on the table. If I add a field to the form from a second table, the records now seem to be sorted by the primary key of the second table.

 

[gemma-the-husky]

you need to base your form on a query, not directly on a table

if you base it on a query, you can sort the query into the order you want. in order to do this faster, it is generally useful to add suitable indexes to the table in respect of the default sort order.

 

[RustyRick]

Thanks all for your suggestions. The funny thing is: The table shows up in the order records were added. But the forms sorts by employee. Each employee has a months worth of records and that's how the "Next Record" arrow scrolls through the table records. I'm good to go thanks all.