Update Field in Ascending Order on Form

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

Guest

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..
 
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.
 
go in design mode of table and click indexes....if you
want to see result of your new update, simply press F9
 
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
 
Back
Top