How to get combo box with list and option for new

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.

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.

"Balbina" wrote:

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.

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
on the selected value of the combobox.

"Balbina" wrote:

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.

"Balbina" wrote:

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.