I am getting an 3022 error (duplicate index) in VBA when I try to save a new record, saying that the record has not been saved, but when I go back to check the table, it has been saved. Does anyone know why?

rst.AddNew
rst!<field> = <value>
rst.Update
-> error 3022

First of all, try to enter a record where you now with no doubt that there is no duplicated fields and ensure the record can be saved with no errors. Then enter your problem record making sure that no fields are duplicated. In your table design, if you declare a field to be primary with no duplicates then there should be no way that a duplicate record can be saved in our table.