sort order in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table sorted A-Z. I have a form to input data into another table,
using as a field a combo box from the previous table. The data show up in my
combo box unsorted. How do I get the data sorted in the combo box.
Thanks
Christina
 
First a point of instruction - tables aren't sorted. Records in tables are
unordered. Queries, reports and forms order records for display/report
purposes.

To order the records in your combo box you simply need to add the Order By
clause to the RowSource query. The easiest way to do this is to open the
query in design view, find the column you want to order by and then click
the down arrow in the Sort field under that column.
 
Sandra Daigle said:
First a point of instruction - tables aren't sorted. Records in tables are
unordered. Queries, reports and forms order records for display/report
purposes.

To order the records in your combo box you simply need to add the Order By
clause to the RowSource query. The easiest way to do this is to open the
query in design view, find the column you want to order by and then click
the down arrow in the Sort field under that column.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have a table sorted A-Z. I have a form to input data into another
table, using as a field a combo box from the previous table. The
data show up in my combo box unsorted. How do I get the data sorted
in the combo box.
Thanks
Christina
Click to expand...


Thanks. OK< I was unclear. I sorted one column in the table in AZ order. However, what I need is to have the Combo Box reading that column from that table to be sorted in A_Z order . I am not at that point using a query. Do I have to?Thanks
Click to expand...
 
If you want it sorted then you will need a query.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Sandra Daigle said:
First a point of instruction - tables aren't sorted. Records in
tables are
unordered. Queries, reports and forms order records for
display/report
purposes.

To order the records in your combo box you simply need to add the
Order By
clause to the RowSource query. The easiest way to do this is to open
the
query in design view, find the column you want to order by and then
click
the down arrow in the Sort field under that column.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have a table sorted A-Z. I have a form to input data into another
table, using as a field a combo box from the previous table. The
data show up in my combo box unsorted. How do I get the data sorted
in the combo box.
Thanks
Christina
Click to expand...


Thanks. OK< I was unclear. I sorted one column in the table in AZ
order. However, what I need is to have the Combo Box reading that
column from that table to be sorted in A_Z order . I am not at that
point using a query. Do I have to?Thanks
Click to expand...
Click to expand...
 
Sandra Daigle said:
If you want it sorted then you will need a query.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Sandra Daigle said:
First a point of instruction - tables aren't sorted. Records in
tables are
unordered. Queries, reports and forms order records for
display/report
purposes.

To order the records in your combo box you simply need to add the
Order By
clause to the RowSource query. The easiest way to do this is to open
the
query in design view, find the column you want to order by and then
click
the down arrow in the Sort field under that column.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Christina wrote:
I have a table sorted A-Z. I have a form to input data into another
table, using as a field a combo box from the previous table. The
data show up in my combo box unsorted. How do I get the data sorted
in the combo box.
Thanks
Christina


Thanks. OK< I was unclear. I sorted one column in the table in AZ
order. However, what I need is to have the Combo Box reading that
column from that table to be sorted in A_Z order . I am not at that
point using a query. Do I have to?Thanks
Click to expand...
Click to expand...

Thanks. I got it.
Christina
Click to expand...
 
I have a table sorted A-Z. I have a form to input data into another table,
using as a field a combo box from the previous table. The data show up in my
combo box unsorted. How do I get the data sorted in the combo box.
Thanks
Christina
Click to expand...
Kpio
 
Hi Christina,

go to the design view of the form

turn on the properties window

from the menu --> View, Properties

click on the combobox control

in the properties window, click on the data tab

click in the RowSource property

click on the Builder (...) button to the right

this takes you to a screen ythat works just like the query
design screen

once you are done making the changes, from the menu, choose
File, Close

and then click YES to update changes

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Back
Top