dbo recordset

B

BillH

Can someone offer me advice on the following?

I am creating a dbo recordset based on a stored proceedure. I am using
Access 2003 and this is an Access Project.

I am trying to create the recordset at follows:

Set rstCandidatesFilteredForReport =
dbInfo.[dbo].[uspCandidates_EmpMasterData_Dynamic](GetKey(), lngUserPerNbr)

I get an error saying, Method or Data Member not found, with the focus
ending up on ".[dbo]"

I have also tried it this way:

Set rstCandidatesFilteredForReport =
dbInfo_OpenRecordset([dbo].[uspCandidates_EmpMasterData_Dynamic](GetKey(),
lngUserPerNbr), dbOpenSnapshot)

That gives me an "Object Required" error.

Can someone help me with the right way to set up this recordset, pulling
from the stored proccedure?

Thanks!
 
Top