Retain combo box order

[Bird Byte]

Hi. I have a 2 column combo box with a query for its row source. The query
includes one lookup table (2 fields: ID and Description), with the id
ascending. The bound column is one; column 1 is hidden.

If I open the form, choose a value from the combo box, go to design view,
then go to form view, the the combo box lists the last item that was
selected. Shouldn't the combo box reset back to the sort order? Can it be
made to reset?

Thanks for any help.

 

[KARL DEWEY]

You are thinking backwards. When you make a selection in the combo that is
bound it writes that selection to the record where it is bound. So opening
in design view and back again does not change the data you wrote to the
record.

 

[Linq Adams via AccessMonster.com]

In point of fact, even if the combobox is UNBOUND, you'll see the same
behavior! Going from Form View to Design View then back to Form View is not
the same as closing the form then opening the form.