Question

[faca]

Hello!

I have mechanic database, this database has form where i select parts and make something similar to invoice. Problem is that sometimes (not always) sorting is messed up.

This is just example!

Selected items:

Bread 1kg 5€
Water 5l 10€


Snickers 1 piece 2€
Bounty 2 pieces 6€

after i close form or exit access and come back to check selection again it would be like this (messes up sorting):

Water 5l 10€
Snickers 1 piece 2€
Bread 1kg 5€
Bounty 2 pieces 6€

where is the problem? i mean it's not doing this always..

[June7]

Looks like descending sort. Access only sorts when it's instructed to.

If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

faca,

Show readers your table design(s). Forms are the preferred method for users to interact with your database. Forms are like a window through which data in table(s) can be read/written.
Tables do not have any inherent sort order. Queries with a specified ORDER BY clause will provide a means for consistent sort order.
Good luck.