Hello;
I'm getting the same error message as Eric but I need to filter for 
specific records in a recordset.  A SELECT query would be inefficient for 
my needs.  Here's my filter and the problem is with the date comparison in 
the last AND.

   rst2Clone.Filter = "EmployeeID = " & strEmployeeID _
                        & " AND RecordDate = " & strRecordDate _
                        & " AND TeamID = " & strTeamID _
                        & " AND [DispatchTime] = " & datDispatch

The data type for both DispatchTime and datDispatch is Date/Time and the 
actual date in both variable is "6/8/2002 11:32:25 AM" (without the 
quotes, of course).  Can anybody help.  Thanks.
Phillip