ComboBox processing in Access 2k

Hi there ...

This may sound kinda amateurish but I'm looking for a good way to handle a combobox dilemma of mine ... What I have is a combobox with 1 column : Work Orders. This ComboBox when selected will put its value into a listbox and remove the value so that it cannot be selected again ... Now, my dilemma. I don't want to reload the combobox say when I remove an item from the listbox ... That is when I delete a work order from the listbox I want to make it available again in the ComboBox ... I do have a thought of having an invisible ComboBox that would hold the selected items and then just move them back and forth between the Combos ... Any ideas or suggestions?

Thanks.

- Mike
[727 byte] By [M Owen] at [2007-11-18 2:12:10]
# 1 Re: ComboBox processing in Access 2k
Why don't just add it back to the combo before deleting it from ListBox?

Something like:

Combo1.AddItem List1.Text
List1.RemoveItem (List1.ListIndex)

If you want them ordered well it's other situation
nikidd at 2007-11-10 0:02:39 >
# 2 Re: ComboBox processing in Access 2k
Good idea! Sometimes you gotta step back and see the forest for the trees ... Even some of us old-timers get lost in the forest ...

- Mike
M Owen at 2007-11-10 0:03:39 >