why this wont filter the recordset?

R

rocco

Hello I have the code below to filter a recordset trough code
It seems not working properly...actually..not working at all.
And it seems the problem are this section of the line: VISIT IS NOT NULL AND
TOTHAM_17ITEMS IS NOT NULL

Code here:
rst .Filter = "ID=" & IDs.Fields(0) & " AND VISIT<>'0' AND VISIT
IS NOT NULL AND TOTHAM_17ITEMS IS NOT NULL"

Why?

Thanks,
Rocco
 
Top