Retain combo box order

  • Thread starter Thread starter Bird Byte
  • Start date Start date
B

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.
 
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.
 
Back
Top