Stored Procedure Call Failing

[Ray]

Not too sure about access but I think you might need to
put the string 2 OR IS Null into single quotes, i.e. '2
OR IS Null'

-----Original Message-----
Hi all,

I've got a report that I open with two parameters (see below). When I open
the stored procedure in design view and put in "=2 OR IS NULL" the SP works
fine... when I try to pass the parameter (below) I receive an error message
saying invalid SQL something or other... any ideas on how to pass a
multipart parameter???

Many thanks!!!!


Dim strRecordSource As String
strRecordSource = "Exec

[spWorkOrder_byAssignedTo_Department] 1 ,2 OR IS