How to get combo box with list and option for new

[Balbina]

I'd like to set up a combo box to populate with the values from a table of
shipment numbers and to give the option of adding a new shipment where if
"new" is selected it will run code to get the next available shipment number
(that I already wrote).

This would be similar to setting the shipment_number to autonumber, but I
want it to be safe from accidentally skipping numbers and I want it to
explicitly say "new".

Any ideas?

Thank you.

 

[Balbina]

OK, the previous post "Update Combo Box" actually answered this, but I'd
still like to know in which event the code should go for when a selection has
been made.

Thank you in advance.

 

[DrGUI]

Use the AfterUpdate event on the combobox. THis triggers the AfterUpdate
event once a selection is made. You can then do what needs to be done based