I have a form with a listbox showing 15 competencies linked by Comp_ID and a subform linked to query1 showing all staff with all competencies. when i highlight a competency from the list box the subform reduces the records based on that competency.. GREAT! what i want to do is use a multi selection on the list box that then shows me staff who have all selected comptencies. how do i do this?