how do I interpret this into usable data for query search
as I suggested
but that is slightly wrong, it should be
eval("|" & ID & "| in (|" & forms!myform!selectedlist & ")")
So your report query will look something like
SELECT *
FROM myTable
WHERE eval("|" & ID & "| in (|" & forms!myform!selectedlist & ")")=true
I made the changes & uploaded the database.
also, updated form location & I keep getting an error the expression is typed incorrectly....