Parameter Problem

C

Cameron Frasnelly

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
NULL "
Me.RecordSource = strRecordSource


Cameron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stored Procedure Call Failing 0
Record Source Input Parameters 0
Forms to input parameters in ADP 4
Help with WHERE filter on opening report from dialog 5
Dynamic Stored Procedure 5
Date parameter 10
Using Stored Procedures With Access Data Project 2
Too few parameters error with a IIF statement 5

Top