Can you update a recordset bound to a form with a Stored Procedure?

[u104741]

Im not sure if this will work but what I am trying to achieve is to use a stored procedure to created a temporary table, bind that temporary table to a continuous form and allow users to update records within it is that possible or is there a better way???

My overall goal is this; I have some data that I must crosstab to get into a format that I can display on the screen. If I bind that to a Continuous Form it dispays just perferct, but.. i need users to be able to update the cells!!

I believe that becuse im using a crosstab the data is not directly updateable is that correct?? so thought that by binding to a temp table i would be able to capture the users changes. Then using some VBA code i can id what fields and records have changed and update my main table.

So by binding my temp table to my form do I get a recordset that is updateable??

Hope someone can help me!!

Cheers,
jj

 

[cmmrfrds]

If you open up an ADO connection to sql server then sql server will keep any temp tables until you drop the connection or drop the temp table.

So you can multi step processes like.

cn.execute dbo.sp_thatbuildstemptable
cn.execute dbo.sp_thatbindstemptabletoupdatetable
cn.close

set cn = nothing