The problem is linked to the closure of the default workspace in line 1210 upon which the form's RecordsetClone somehow depends – if any one knows how and why, please let me know. What is the proper way of running a transaction on the current database in a separate workspace? Creating a new...
Form some reason the form's RecordsetClone becomes corrupt. I replaced line 100 where the error occurs with rsForm.FindFirst "lntID = " & Me.ID_ctl.Value and also moved out lines 1070 and 1090 where the closing of rsForm and rsSubform occurred, following recommendations in a post by LPurvis...
Thank you, plog, for weighing in. Reason for the temporary table is that the user has to manipulate some data and then decide on whether to make changes permanent or not. I had envisaged writing directly to the target tables and wrapping everything into a transaction, however, this interfered...
Hi there!
Plan: Stuff is written for user review into a temporary table. The table is tied to a form which allows the user to conveniently review the records. Upon button press information contained in the current record gets written to other tables and after successful operation, the current...