Wrong sorting order in a form from an Access Project

[Adrian]

I am using Access 2002 and for about a week I am trying to migrate to SQL Server, but I still want to use the Access interface that I created....But I've got one big problem: when i have a field that has 2 rows as a source (the ID which is hidden and which is being used for relations and the name which is the displayed text) and i am trying to sort after that field...the result is shown sorted after the ID (the hidden part). How can I fix this and see the result sorted after the displayed text??

 

[Damon Heron]

If I understand you correctly, you just need to use a query for the form's
source, as
SELECT AccountID, AccountCN
FROM AccountingStuff
ORDER BY AccountCN

HTH
Damon

I am using Access 2002 and for about a week I am trying to migrate to SQL

Server, but I still want to use the Access interface that I created....But
I've got one big problem: when i have a field that has 2 rows as a source
(the ID which is hidden and which is being used for relations and the name
which is the displayed text) and i am trying to sort after that field...the
result is shown sorted after the ID (the hidden part). How can I fix this
and see the result sorted after the displayed text??

 

[Adrian]

it is not about the form's source.....it's about sorting data in a form after a column that has data selected just as you described. Only that when i sort it...the result is shown sort after the id, not after the visible data