Cannot set AccessRecords. . .
This question is worth 250 points. I would like the answer to be as specific as possible. Thanks!
I have a datagrid on one of my Forms, which shows the members of a department. The grid works fine, except for when it gives me an error, which occurs from time to time. If I click on the grid repeatedly (trying to error test the Form) after numerous clicks on different fields, I get a message box that says:
Error when committing the row to the original data store. < -- In the title bar
Cannot set AccessRecords. Do you want to correct the value? < -- In the message body
YES NO
Why is this happening and how can I correct it?
Any thoughts would be appreciated
I have a datagrid on one of my Forms, which shows the members of a department. The grid works fine, except for when it gives me an error, which occurs from time to time. If I click on the grid repeatedly (trying to error test the Form) after numerous clicks on different fields, I get a message box that says:
Error when committing the row to the original data store. < -- In the title bar
Cannot set AccessRecords. Do you want to correct the value? < -- In the message body
YES NO
Why is this happening and how can I correct it?
Any thoughts would be appreciated
ASKER
No, the I did not code the message box that I described above. I have no message boxes that even come close to that kind of verbiage. The message is being generated by the system itself.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sancler, thank you for the research you provided. I'm going to award you the points because of your efforts, which I do appreciate. I was not able to determine what exactly it was that causing the error, but I made a few changes based on the info you provided and made the error stop happening. Thanks again.
Roger