Use a Multi Select ListBox
If you want multiple selections the only way I know how to do it is in code.
Use a multi select list box and convert each selected item (see the ItemsSelected collection of the list box in Access's help) into a string such as
'start code
dim strSQL as string
For Each varItem In rctlListBox.ItemsSelected
if len(strSQL)=0 then
strSQL = varitem
else
strSQL = varitem & "," & varItem
end if
Next
strSQL = "S.SkillID IN(" & strSQL & ")"
'end code
wrap it in a function for reuse.
"S.Skills IN('VB','SQL','C++')"
OR "S.SkillID IN( 1,2,3,4 etc)"
Looking at your table design
(SkillID, PersonID, skill) - this is incorrect usually. Skill depends on the SkillID - so it should be in a seperate table
So
tblPersons
PersonID
Address
FamilyName
etc
tblSkills
SkillID
SkillName
etc
tblPersonsSkills
PersonID
SkillID
What you are modelling is a many-to- many relationships between people and skills.
HTH,
Peter