Have values in Not In List sorted after new addition

[forest8]

Hi there

I have a created a not in list event which will add new values if it's not
already in the list.

When a new value is added, how can I get the values sorted?

Do I have to add anything to my notinlist event? Or should I do something
else?

THank you for your help.

 

[Paolo]

Hi forest8,

if your list is sorted a requery after you inserted the new value is enough
to have your list sorted again.
Actually the sorting of the list depend on what you sort the row source in
the properties of the combo so if you sorted it on, for example, the field
surname the list after the requery will still be sorted on the surname field
with your new data inserted.

HTH Paolo

 

[Marshall Barton]

I have a created a not in list event which will add new values if it's not
already in the list.

When a new value is added, how can I get the values sorted?

Do I have to add anything to my notinlist event? Or should I do something
else?

Change the combo box's RowSource to a query that sorts the
records.