Connecting Tech Pros Worldwide Forums | Help | Site Map

problem when editing the data in the ms access table

ammoos's Avatar
Member
 
Join Date: Apr 2007
Posts: 89
#1: Jun 18 '08
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 “SelectionStatus”. So when I click on this check box, the “SelectionStatus” 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 “SelectionStatus” 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

ammoos's Avatar
Member
 
Join Date: Apr 2007
Posts: 89
#2: Jun 19 '08

re: problem when editing the data in the ms access table


Please help me........
Reply