Retain combo box order

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.
 
K

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.
 

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

Similar Threads

Undo Combo Box Selection 2
Order of Records in Combo Box problem 4
Problem with NotInList 1
Adding All to a combo box 5
Intractable Combo Box problem! 1
Retriving more than one value from a combo box 3
Change query on combo box if it meets criteria 1
Combo Box Values 2

Top