Moving Data Between Two Combo Boxes

[HardingR2000]

I want to create a form with two combo boxes. cmboA contains all products. cmboB contains only those products that have been selected from cmboA. Once it has been selected from cmboA and moved to cmboB it needs to be "removed" from cmboA via a change in the WHERE logic which defines the record source for cmboA. I think I know how to implement this. What I don't know is the following.

I have seen other language applications that move data between two combo boxes using a left arrow (<) button and right arrow (>) button which moves the selected value from the left combo box to the right combo box and vis-a-versa.

Does Access have similar functionality and if so what is it called and how do I implement it? Or is there a better way?

Thanks

 

[TheAceMan1]

How are ya HardingR2000 . . .

Have a look below ... same should work for comboboxes only no double-click.

Adding and Removing Items Between Two Listboxes

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MajP]

Faq702-6326
Gives two examples for listboxes. The first example requires the user only to write six lines of code to make it all work because the functionality is incorporated in a class module.

I assume you mean list boxes. Combos does not seem like a logical choice.

 

[HardingR2000]

Thank you for your help. It is working wonderfully.

 

[Smeg77]

I found this in my recent searches for help with Access, I think it does waht you are asking, one Independant Combo Box, and one that Depends on the other.

http://www.blueclaw-db.com/download/dependent_combo_box.htm