IF !EMPTY(m.cErrorMessage) =MESSAGEBOX(E_FAIL_LOC+m.cErrorMessage) ENDIFproduces the error message "Table not updated: relpos. Unique index violation:". if I change to a "Regular" index I may get more than 1 record for the key field "crelpono" with the code
UPDATE relpos SET dpodate = Thisform.txtPoDate.Value , ; drecieved = Thisform.txtDateRecieved.Value , ; dreleased = Thisform.txtDateReleased.Value , ; corderedby = Thisform.txtOrderedBy.Value , ; ccomment = Thisform.txtComment.Value . ; cvname = ThisForm.txtvendName.Value ; WHERE crelpono = Thisform.txtFindRelPoNo.Value ThisForm.txtPoNo.Value = Thisform.txtFindRelPoNo.Value ThisForm.txtFindRelPoNo.SetFocus() ThisForm.lblstatus.Caption = 'Viewing Data'What I do not understand is why the "Save" command gives the error message when I find the value via a "Vaid" method which has extra validation code and an "Interactive Change" method which has only valid values in the drop down. If I change to a "Regular" index I may get multiple records. What I need to know is either how to avoid the error message for a "Candidate" index or multiple records for a "Regular" index.