Here is my example of a user pick list. The user can pick items from a list (dbl-click) the items are added to a Picked list table.
This table can be joined to the main table to pull ONLY the items chosen. (rather than have a query with many OR clauses)
It also has filters by Letter or State to help speed up selections.
below are the queries/events that go with the various controls...
select [name], [state] from tClients where [name] like "*" & forms!frmPick!lstAlf & "*"
select [name], [state] from tClients
select [name], [state] from tClients where [state] = forms!frmPick!lstState
select * from tPicked
INSERT INTO tPicked ( Name, State )
SELECT [Name] ,[State] FROM tClients
DELETE * FROM tPicked
DELETE * FROM tPicked where [name] = forms!frmPick!lstPicked