Re: Combo Box based on Query sort not working - A2K

I assume that you're clicking on the rowsource button in the
properties window to edit the query, right?

Does the row source query change when you save and close the form and
then reopen it?

If you can change the rowsource to "SELECT Departments.DeptCode,
Departments.DeptName FROM Departments
ORDER BY Departments.DeptName;" but the next time you open the form
the order by clause is gone or different I'd look for an "On Open" or
"On Activate" event in the form that _may_ be resetting the
rowsource. If the order by clause is there all of the time we've got
other problems.

A decompile probably wont help, but it couldn't hurt (as long as you
have a good backup).

hth,
tim mills-groninger

On Feb 27, 11:12 am, sara <saraqp...@xxxxxxxxx> wrote:

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!
...

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

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

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

.

Quantcast