I'm new to VB so I may be going about this all wrong, but here's what I want to do and the problem I'm having. I have a form that creates a recordset from a SQL stored procedure. I want to use this recordset as a datasource for a crystal report. Here's the command I use to create the recordset

rstletter.Open "custlett ('" & Trim(job) & " ')", _
g_objConn, adOpenDynamic, adLockOptimistic, adCmdStoredProc

I get the error "error detected by database DLL" when it attempts to run the following line of code.

Report.Database.AddADOCommand rstletter.ActiveConnection, rstletter.ActiveCommand

Any ideas?

TIA

Kris