combo box based on view not sorting properly

[jordanking]

Hello,

I have begun the fun task of upsizing an access db to a adp front end with a sql 2005 express backend. I have a form with a combo box based on a view. The view has some ascending sort values and it displays properly when opened by itself. But when it is specified as the list value for the combo box, the sorting is ignored. does anyone have an idea as to why this happens.

this is the view:

SELECT      TOP 100 PERCENT idsCompanyID, txtName + ' ' + ISNULL(txtBranch, '') AS Company, txtPhone, txtName, txtBranch
FROM          dbo.tblCompany
ORDER BY txtName, txtBranch

 

[jordanking]

This version of the view does not sort properly as well,

SELECT      TOP 100 PERCENT idsCompanyID, txtName + ' ' + ISNULL(txtBranch, '') AS Company, txtPhone
FROM          dbo.tblCompany
ORDER BY txtName + ' ' + ISNULL(txtBranch, '')

 

[ajrimmer]

Have you tried something like:

[b]
SELECT TOP 100 PERCENT Company, txtPhone, txtName, txtBranch 
FROM
([/b]SELECT TOP 100 PERCENT idsCompanyID, txtName + ' ' + ISNULL(txtBranch, '') AS Company, txtPhone, txtName, txtBranch
FROM          dbo.tblCompany[b])[/b]
ORDER BY txtName, txtBranch