Currently have a database with 3 fields set as primary key so that duplicates will not be saved. I also inserted an On error message below to display an error message. The final step would be to take the user to the already existing record. Any ideas on how to accomplish this? Is there some code that I could add to the on error message to take the use to the already existing record. The three fields are Loan_Number, Investor_Number and Request_Type. Thanks for the help.

Err_Save_Record_Click:
Select Case Err
Case 3022
MsgBox "A record with this Loan Number already exists.", vbOKOnly, "Record Exists"
    
Case Else


Exit Sub
End Select