andysgirl8800
Registered User.
- Local time
- Today, 04:07
- Joined
- Mar 28, 2005
- Messages
- 166
Wow! I really thought this was going to be so much easier! I've read through just about every post and thread referencing list boxes and really can't seem to find a solution.
Situation:
I have a list box (listboxA) on my form (SelectList) that displays a list of values from my table (tblMisc). I would like the user to be able to select multiple options from this list box which will then populate the second list box (listboxB) with those choices. Selections may be made one by one, or in groups at a time, so I need the second list box to accept single or multiple entries and accumulate them until the user has selected all applicable items from the first list box. Then, I would like the user to be able to print the list of items that they selected (stored in the second list box). The user is bound to make erroneous selections, so I need the user to be able to deselect an item from the second list box. Finally, I need a "clear all" button to remove all selections from the second list box so a new user can make their selections.
Problem:
I may have bitten off more than I can chew. I have the form and list boxes set up. They are correctly displaying data. However, if I have selected a single item from my list and want to add it to the second list box, my original selection(s) are being overwritten instead of accumulating. I have also attempted several unsuccessful codes to be able to remove an unwanted selection from my second list box. Because of these road blocks, I haven't even been able to ATTEMPT the print function. I've reviewed many threads and examples here, but struggle when I cannot open zipped files due to my company's firewalls.
Question:
Is there an easier way to do this? Am I missing a very simple step that will allow me to use these list boxes the way I need them? Any help or suggestions would be greatly appreciated! I am currenlty using Access97. Thanks so much in advance!
Situation:
I have a list box (listboxA) on my form (SelectList) that displays a list of values from my table (tblMisc). I would like the user to be able to select multiple options from this list box which will then populate the second list box (listboxB) with those choices. Selections may be made one by one, or in groups at a time, so I need the second list box to accept single or multiple entries and accumulate them until the user has selected all applicable items from the first list box. Then, I would like the user to be able to print the list of items that they selected (stored in the second list box). The user is bound to make erroneous selections, so I need the user to be able to deselect an item from the second list box. Finally, I need a "clear all" button to remove all selections from the second list box so a new user can make their selections.
Problem:
I may have bitten off more than I can chew. I have the form and list boxes set up. They are correctly displaying data. However, if I have selected a single item from my list and want to add it to the second list box, my original selection(s) are being overwritten instead of accumulating. I have also attempted several unsuccessful codes to be able to remove an unwanted selection from my second list box. Because of these road blocks, I haven't even been able to ATTEMPT the print function. I've reviewed many threads and examples here, but struggle when I cannot open zipped files due to my company's firewalls.
Question:
Is there an easier way to do this? Am I missing a very simple step that will allow me to use these list boxes the way I need them? Any help or suggestions would be greatly appreciated! I am currenlty using Access97. Thanks so much in advance!
