Combo Box - Ordering Typed in data.

[qvqv]

When a combo box is set where the person entering the data, can type in values:

1) Is there a way to order the list alpabetically or numericaly.

2) If the data is sorted manually, does this affect the relationship between the record and the data from the combo box?

Many thanks in anticipation

[Bob Fitz]

What is the Row Source property of the combo.
If it is derived from a table/query you will be able to sort it by any field.

[ranman256]

in the combo bound query put 2 fields:
1, for the user to see and choose
2, the sort.

[moke123]

Is it a value list or based on a query? How are they typing in the Info? Are you using the not in list event?

[qvqv]

Its a value list.

Type in by user.

Many thanks

[Micron]

Could be done but would require code. The smartest thing would be to not use a value list and utilize the NotInList event to allow additions. The code effort to re-order a value list would be more effort than using a lookup table IMO.

[Micron]

The smartest thing would be to not use a value list and utilize the NotInList event to allow additions

By that I meant additions in a back end lookup table (if fe, users would lose these values upon each fe update). If you want a whole lot of reasons to not edit value lists, read

http://allenbrowne.com/ser-27.html

[qvqv]

Thanks quite convinving. Thanks

[orange]

I agree with micron. You may get some additional insight from this youtube video by Richard Rost.