Combo box - how do I sort ascending?

[maacky99]

Hello, I am trying to "touch up" a database that I did not create, and I am sitll a beginner at Access.

I have a combo box on a form, the control source is:

SELECT [ProblemFound].[ProblemFound] FROM ProblemFound;

How can I get this to sort in ascending order? The table it is derived from only has two rows - autonumber, and ProblemFound

Thanks!

 

[namliam]

SELECT [ProblemFound].[ProblemFound] FROM ProblemFound Order by [FieldName]

Greetz

 

[Mile-O]

Make a query based on the table. Set the query as the combo's RowSource.

The SQL for the query will be:

SELECT autonumber, ProblemFound
FROM ProblemFound
ORDER BY ProblemFound;

Don't put this SQL into the RowSource as it is faster - and a better practice - to cite a query as the rowsource rather than an uncompiled SQL statement.

 

[maacky99]

Thanks for both responses!!!

I also prefer to use the query method - and I am trying to make my way through this large database to do so.

Thanks again