Display Order of Second Column

  • Thread starter Thread starter Eddy
  • Start date Start date
E

Eddy

This is probably an easy one. I have a query with two fields. The first is a
number field and the second has a description of what the number represents.
It is text. When I run the query from the form I want the second field to
be in alphabetical order, A to Z. When in disign mode at the database
window and I just run the query it works.yet when in the form and I use the
combo box to run the query the first field is in order 0 to 999 or whatever.
The second field is not. How can I get the query to display correctly from
the form?
Thanks
 
This is probably an easy one. I have a query with two fields. The first is a
number field and the second has a description of what the number represents.
It is text. When I run the query from the form I want the second field to
be in alphabetical order, A to Z. When in disign mode at the database
window and I just run the query it works.yet when in the form and I use the
combo box to run the query the first field is in order 0 to 999 or whatever.
The second field is not. How can I get the query to display correctly from
the form?
Thanks
Click to expand...

Base the Combo Box on a Query, and specify the desired sort order in
the query. But I'm not sure what you mean by "use the combo box to run
the query" - a combo doesn't *run* a query, it usually *displays the
contents* of a query. Am I missing your point here?

John W. Vinson[MVP]
 
No, you nailed it. Thanks so much for the help.
John Vinson said:
Base the Combo Box on a Query, and specify the desired sort order in
the query. But I'm not sure what you mean by "use the combo box to run
the query" - a combo doesn't *run* a query, it usually *displays the
contents* of a query. Am I missing your point here?

John W. Vinson[MVP]
Click to expand...
 
Back
Top