Combo Box based on Query sort not working - A2K

Hi -

I have been asked to change a combo box display to sort in
alphabetical order. This is in an app I did not write, but it should
be simple enough!

The combo box is based on a table (and I've put in SQL and a query -
same problem)

It is 2 columns, bound column 1, width 0,2".

Query: SELECT Departments.DeptCode, Departments.DeptName
FROM Departments
ORDER BY Departments.DeptName;

When I run the SQL or the Query, stand-alone or from the properties
window, the sorting is correct (in Dept Name order).

The combo box still displays in DeptCode (Number) order.

I tried changing the number of rows to display (from 8 to 20) and the
column widths (to .5", 2") and nothing changes in the display! Still
shows 8 rows, in number order.

It's like it's not taking my changes or it's getting its direction for
the combo box from somewhere else.

Any ideas? Would a decompile be any help at all? There's lots of
code in the app, but little in the form and nothing with this combo
box.

Thanks -
Sara
.

Relevant Pages

  • Re: ODBC Timeout problems but very hard to pin down
    ... APP 1: Access 2000 database ... I ran SQL Profiler to capture the ... validated by SQL Server. ... As it happens, the default display contains ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: display array in a frame wnd
    ... you have to create an app that is suitable for displaying an image. ... There would never be a need to create a frame window; it is not at all clear why such code ... I have to display results. ... Why is this not in an OnPaint handler? ...
    (microsoft.public.vc.mfc)
  • Re: Select DISTINCT...wont select DISTINCT
    ... I thought I was starting to get the hang of SQL, at least a little, but this ... [Advertising Entity Name], ... FROM [Display Entity Mapping]) ... your table structure is going to make your query not work in a usefull ...
    (microsoft.public.access.queries)
  • Re: Combo Box based on Query sort not working - A2K
    ... This is in an app I did not write, ... The combo box is based on a table (and I've put in SQL and a query - ... I tried changing the number of rows to display and the ...
    (comp.databases.ms-access)
  • Re: Expression help in Query
    ... query to another database, it doesn't work because it says something about ... note that i change the name of your field alias from BranchItemTrans to ... note that i didn't "vet" the rest of your SQL ... If record is 55, then display 51-100 ...
    (microsoft.public.access.gettingstarted)