Transfer of Data from Combo Box

[Newguy28]

Hi Guys,

Ok, all i want to do is that when i select a value from my combo box to be displayed in a text box, once its been selected, the value is then deleted from the combo box, any ideas????

 

[DJN]

Why do you want to delete a value from a combo box? What exactly are you trying to do?

 

[Newguy28]

The combo box holds a list of unallocated part numbers, so when a new part is added, you select a new part number from the combo box for it, and then that part number is displayed in the text box and i want it deleted from the combo box so that its not selected again!! Hope you got that!!

 

[RuralGuy]

What is the RowSource of your ComboBox? It should be a query/table. You need to delete the record selected by the user in the AfterUpdate event of the ComboBox and then Requery the ComboBox.