Record navigation buttons work backward

[jonesy29847]

It is set as follows:
[Task].[TaskDate] DESC, Is that my problem?

[RuralGuy]

The DESC stands for Descending which means in reverse order or biggest date first.

[jonesy29847]

I changed to ASC still same issue.

I am truly perplexed.

Is there no way out of my problem?

[RuralGuy]

Why do you even have an OrderBy Clause in the Form? Delete it. If you need a particular order then create a query with the OrderBy Clause in it and set your form's RecordSouece to the Query and not the table.

[jonesy29847]

Thanks RG, I tried changing it to ASC, then deleting, but navigation is still backwards.

[RuralGuy]

Set "Order By On Load" to NO as well.

[jonesy29847]

OK, RG, That works! Thanks a ton!

[RuralGuy]

Great! Glad we could help.