append recordset returned from a stored procedure

I have a recordset returned from a stored procedure executed in the form open event. Could this recordset append to the form's recordsource property in the form's open event in VB? if so, what's the syntax?

Private Sub Form_Open(Cancel As Integer)
dim ...

Set add_bag_results = Nothing
With add_bag_results
.ActiveConnection = CurrentProject.Connection
.CommandType = adCmdStoredProc
.CommandText = "spSampling_add_bag_results"
.Parameters.Append .CreateParameter("ret_val", adInteger, adParamReturnValue)
'.Parameters.Append .CreateParameter("@.lotnum", adInteger, adParamInput, 4, rs_add_bag_results(1))
.Parameters.Append .CreateParameter("@.lotnum", adInteger, adParamInput, 4, lot_n)
..
Set rs_add_bag_results = .Execute
End With

Me.RecordSource = rs_add_bag_results ?

Thanks!I think this is a very insightfull question but your on the wrong forum for this I think. Try Extreme, VB.com, the response is just as quick and it's the same format as this forum. Frankly, I don't know vb but when I had to use it with asp.net I used Extreme vb forum for my code.|||Thanks for your reply. I did figured it out. You are right and I have posted my questions on vb extreme forum before. Thanks!

Anyway to schedule a report to deploy automatically

Can this be done with ssis or executed in a package?

You only deploy a report when the definition changes. Do your modify your reports on a regular basis? If that is the case then I would suggest writing a little program using the SQL Reporting Services WebServices API. You can do just about anything with it!|||Nevermind, it's the table that is getting updated and the report is already there.