Preventing duplicate data entry
How to prevent duplicate data entry in different records. Q: Nigel Heremaia wants to prevent users from entering the same data in the FirstName and LastName fields in different records. He is using this code, but it isn’t working: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim FirstName Dim LastName Dim FullName FirstName = DLookup(“[FirstName]”, […]