A2K, Error: 2757, OLE Object Error

S

seeCoolGuy

So I have an ADP form where I typically just do a simple

me.RecordSource = "Exec stp_001_MyFavoriteSproc " & nz(me.chkAll, 0)

I've done this in other forms, the data source is diffrent but the call
to it is the same, and I end up with the Error:2757, Unable to access
the OLE object (error).


So I modify my call like so:

Set rs = new adodb.recordset

currentproject.connection.stp_001_MyFavoriteSproc nz(me.chkAll,0), RS

If I check the recordset like so
rs.recordcount

I'll get my 6 rows, but If I try populate the form w/ the same
recordset the form never completes it's re-draw... what gives?
set me.form.recordset = RS
 
Top