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.




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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question