[RESOLVED] SQL IN WHERE condition using textbox on form

[rack]

I'm trying to get a report to limit to the regions/departments that are specific to the ones in a textbox in a form.

I can get them to display in a report by using the .value, however I now matter what I do, I can't get it to display anything if I put it in the IN condition.

SELECT Rgn_dept, forms!frmReports!txtAllRegions.value
FROM MyTable
WHERE  Rgn_dept IN (forms!frmReports!txtAllRegions.value)

I have even tried

SELECT Rgn_dept, forms!frmReports!txtAllRegions.value
FROM MyTable
WHERE  Rgn_dept IN (forms!frmReports!txtAllRegions)