How do I capture an associated Count field in a list box
Posted on 2014-08-19
I have a unbound 7 page tabbed form and within one of the page/tabs I have a list box where the user can select multiple items. Using the ListBox Selected Item property I loop thru the listbox control to capture each item selected and place in a store table.
My problem is it turns out each selected item also has an associated count field. Thus, if the user selects from the drop-down field an item called "Cars", I should also be capturing the number of Cars. If the listbox is just that..a selection, how would I allow someone to also input a count.
Note since the form is unbound I assume I can not use a temp table for this particular page/tab as the control source. In addition it is very important the person see all the items selected (that is why I am not using a combo box). Also I do not want to create separate text boxes for each item. Currently there are 10 potential items that can be selected, but it will grow quickly.
Any suggestions ?