mediatek01
01-18-2012, 12:02 PM
Hi All,
I'm creating an application in Access 2007 using VBA. I've been scouring the net for weeks trying to find an answer to a problem I'm having. I'm hoping someone on this site could help.
I have a bounded combo-box on a form where multiple items from the list can be selected. It works fine except that I have a requirement that messes things up. The requirement is that order of selection is very important. What I mean by that is that if a user first selects an item from the combo-box list, that item must be the first item in the combo-box text window. If they pick a second item, then that item must be the second in the list (followed by a comma), and so on. Right now that is not the order being dispayed.
Is a combo-box the right thing to use for this? Is there special coding that I need to write that will handle this. Any help in this matter would be greatly appreciated.
Thanks
I'm creating an application in Access 2007 using VBA. I've been scouring the net for weeks trying to find an answer to a problem I'm having. I'm hoping someone on this site could help.
I have a bounded combo-box on a form where multiple items from the list can be selected. It works fine except that I have a requirement that messes things up. The requirement is that order of selection is very important. What I mean by that is that if a user first selects an item from the combo-box list, that item must be the first item in the combo-box text window. If they pick a second item, then that item must be the second in the list (followed by a comma), and so on. Right now that is not the order being dispayed.
Is a combo-box the right thing to use for this? Is there special coding that I need to write that will handle this. Any help in this matter would be greatly appreciated.
Thanks