D
Doc
Getting the following error: "Key value for this row was changed or deleted
at the data store. The local row is now deleted."
ADP with SQL 2005 backend; single form based on SELECT statement, 4
subforms. Main form is based on 'Master' table, 3 sub forms are based on
'Child' talbes, last subform is summary of entered data.
Selection box based on "MachineID", after selection, VB initiated to
determine if all time for machine has been entered, as well as if a main form
record has already been created for certain machine.
Subforms do not allow entry until main form has been saved (because the
linked fields are based on an autonumber field that doesn't get it's number
until the form is saved). The error stated above RANDOMLY occurs when the
Frm.Dirty value is changed to False (saving the data). I have been through
this hundreds of times, I can not link the error to a single pattern. Error
also occurs if I comment out the frm.Dirty = False when I either close the
form or go to another record.
Confused. . .
at the data store. The local row is now deleted."
ADP with SQL 2005 backend; single form based on SELECT statement, 4
subforms. Main form is based on 'Master' table, 3 sub forms are based on
'Child' talbes, last subform is summary of entered data.
Selection box based on "MachineID", after selection, VB initiated to
determine if all time for machine has been entered, as well as if a main form
record has already been created for certain machine.
Subforms do not allow entry until main form has been saved (because the
linked fields are based on an autonumber field that doesn't get it's number
until the form is saved). The error stated above RANDOMLY occurs when the
Frm.Dirty value is changed to False (saving the data). I have been through
this hundreds of times, I can not link the error to a single pattern. Error
also occurs if I comment out the frm.Dirty = False when I either close the
form or go to another record.
Confused. . .