Listbox trick in Access to Add or Remove items ~ DataPig
This video demonstrates a technique to select items from a list and store them in a second list. It also shows how to remove an item(s) from the second list and return it to the first list. This example uses a single table with 2 fields. Field one has the item name, field two is an integer. It is the field two value, either 0 or 1, that is the trick to this technique. List1 rowsource deals with value 0. List2 rowsource deals with value 1. Selecting an item in list1 and moving it to list2 involves an update query. A similar approach moves a selected item in list2 back to list1. Add and Remove buttons are used to execute the update queries. This is a simple and effective way to display selected items in a list and/or return them to the "selectable" list.
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.