I have a combobox that filters my records for a form. I would like to add an After_Update Event that analyzes the results of the returned records, and puts up a MsgBox warning the user if there are duplicates. There are 2 fields that must have duplicate information in order for the record to be considered a duplicate. They are qry_Invoice_Detail_AllClaims. [Invoice Number] and qry_Invoice_Detail_AllClaims.[Amount Invoiced]. Any ideas on how to approach this?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.