If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How to get combo box with list and option for new
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. |
#3
|
|||
|
|||
How to get combo box with list and option for new
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. |
Thread Tools | |
Display Modes | |
|
|