Hi,
I am updating a simple table directly from the form. I can add or update into the table, but when i close the form i am getting the following messages
Msg1 - "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields that contain duplicate data remove the index or redefine the index to permit duplicate entries and try again"
Msg2 - "Microsoft Access may have encountered an error while trying to save a record. If you close this object now, the data changes made will be lost. Do you want to close the database object anyway?"
Can anyone help me how to hide these messages from the screen?
I am updating a simple table directly from the form. I can add or update into the table, but when i close the form i am getting the following messages
Msg1 - "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields that contain duplicate data remove the index or redefine the index to permit duplicate entries and try again"
Msg2 - "Microsoft Access may have encountered an error while trying to save a record. If you close this object now, the data changes made will be lost. Do you want to close the database object anyway?"
Can anyone help me how to hide these messages from the screen?