Run-time error '2580'

[cliftonx]

Hello,

I'm simply trying to change the record source on a form. I'm using SQL Server as the backend. I'm assigning the record source to a stored procedure named: " "spDevsWithPartsSpec" plus passing along the parameter; "Forms!frmiimain.cboJobNumber". I'm getting the following run-time error 2580:

Here is the code that is being executed:

Thanks, for your resolutions in advance.
Clifton

 

[theDBguy]

Hi. newrs has to be declared as a recordset object. You declared rs but did not use it. You could try just using rs and get rid of newrs.

Hope that helps...

 

[CJ_London]

perhaps try

set me.recordset=qf.openrecordset

 

[Gasman]

Can a recordsource have spaces in it?

 

[CJ_London]

the OP is creating a passthrough query, calling a stored procedure with a parameter. Not sure if treating a number as text would have an impact

 

[theDBguy]

perhaps try

set me.recordset=qf.openrecordset

Yeah, I missed that. Recordset vice RecordSource. Thanks for the assist!

 

[Minty]

If it is an Integer data type then you'll get an error returned by SQL server.
It should be

sp_DevsWithPartsSpec 19050