Hi Friends
I have an issue in the MS Access Sub Form
The Sub form contains Student Name, Address and one selection field(it’s a check box. in the database table, it specified as “Yes/No” field. Field name is “SelectionStatu s”. So when I click on this check box, the “SelectionStatu s” field in the table should me update with out any code). I have also placed a checkbox to check all checkbox in the sub form or uncheck it(I done it by updating the “SelectionStatu s” field of the table)
When I click on this “Select All” check box, then the check boxes in the sub form will change as per the selection in the “Select All” check box.
The issue is that, when I suddenly click on the Select All Check box after some selections in the checkboxes in the sub form, a error message box will disply
The Error Message come from the MS Access I think,
Message box Caption: “Write Conflict”
Message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made
Then 3 buttons “Save record” and “Copy to Clipboard” and “drop Changes”
What can I do against displaying this error message.
Please help me as soon as possble
Thanks
Ammoos
I have an issue in the MS Access Sub Form
The Sub form contains Student Name, Address and one selection field(it’s a check box. in the database table, it specified as “Yes/No” field. Field name is “SelectionStatu s”. So when I click on this check box, the “SelectionStatu s” field in the table should me update with out any code). I have also placed a checkbox to check all checkbox in the sub form or uncheck it(I done it by updating the “SelectionStatu s” field of the table)
When I click on this “Select All” check box, then the check boxes in the sub form will change as per the selection in the “Select All” check box.
The issue is that, when I suddenly click on the Select All Check box after some selections in the checkboxes in the sub form, a error message box will disply
The Error Message come from the MS Access I think,
Message box Caption: “Write Conflict”
Message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made
Then 3 buttons “Save record” and “Copy to Clipboard” and “drop Changes”
What can I do against displaying this error message.
Please help me as soon as possble
Thanks
Ammoos
Comment