Originally Posted by
June7
Instead of the 100 choices in a combobox, could be a multi-select listbox. Then code can loop through the SelectedItems and write records to table.
Don't create a table for each playlist, use 1 table and add records as described.
If this is a single-user db, then can have a yes/no field in the master Images table to allow selection of the 10-20 records on the filtered form. Then code would copy each record ID into UserPickList table. This can be accomplished with an INSERT SELECT action. In VBA looks like:
CurrentDb.Execute "INSERT INTO UserPickList(UserID, ImageID, PickListName) SELECT " & Me.tbxUserID & ", ImageID, '" & Me.tbxListName & "' FROM Images WHERE PickImage = True"
Then after that, reset the yes/no field back to all False:
CurrentDb.Execute "UPDATE Images SET PickImage = False"
If this is db will have multiple simultaneous users, this technique will result in user conflicts setting the yes/no field to pick images.
The more 'user friendly', the more code.