Rich -
A follow up question if you have a second:
Everything working great now but one last hiccup - I have bound the disconnected ADO recordset to the form but I can't edit the data and close the form without getting the following error message:
This Recordset is not updateable
This message is followed by the standard "you cant save at this time" error messages...
Now - I know that you can't edit data from a stored procedure but I figured that, by disconnecting the connection I was, bascially, unhooking or unlocking the data... but this doesn't seem to be the case.
What I want to happen is this:
1) - get data from connection & stored procedure
2) - bind the retured recordset to a form for view/edit
3) - enable user to edit record and the click a 'save edit button'
4) - save edit button reconnects to server and runs an update stored procedure that saves changes to backend that the user requests...
Is there a way to do this and get around the error messages OR is there a way to disable these error messages?
Thanks a bunch Rich,
Kev