Hi,
I am using a for to input new data and edit existing data.
I want to avoid entering duplicates. What code should be put in the Before_Update event that does the following:
1- check if a duplicate record exists
2- Cancel the current information already entered in the form (not saving it).
3- go to that existing record.
Khalil