I´m working on a upsizing project with a sql-server backend.
The following problem occured: in the open-form method I defined an ADODB recordset, specified the connection, cursortype, cursorlocation, locktype and assigned the opened recordset to the form.
That works fine, all fields where shown, the recordset can be modified directly with form.recordset("fieldname") = "xyz" but: when I try to modify the field via the bound control like form.control.value = "xyz" there comes the error 2077: recordset cann´t be updated.
Is there something special with that kind of recordset handling? The same sql-statement bound to the form works fine also with updating.