Update Field in Ascending Order on Form

F

Franca

Hello,

I have a table called manufactuers. When there is a new manufacturer I add
it to the table then update the forms accordignly.

In the table I can sort the items in ascending order but after I update the
field it does not show the same results. The manufactuer items that are in
the form of a drop down list, are not is ascending order but just added to
the bottom of the list.

The process I use to update the form: After I update the table I open up one
of the forms and delete the manufactuer field and re-add the field from the
field list. If I don't do this it doesn't update the list.

Since I have a couple of forms with this field, is there an easier way of
doing this and how can I see the list in alphabetic order?

Thanks..
 
F

Franca

the manufacturer field on the form is a combo box that gets its row source
from the table/query - tbl_manufacturer. The control source points to the
manufacturer table as well.
 
G

Guest

go in design mode of table and click indexes....if you
want to see result of your new update, simply press F9
 
G

Guest

Go in design mode of tbl Manufacturers, and enter the
field you want in ascending mode.

After you entered the info for a new record, press
F9..this will update your table....if you look again in
dropdownlist it should be in ascending order
 
Top