Flag duplicate entries

[dar]

I have table which does allow duplicate names (schedules) but I want to code
the entry form to alert that a duplicate may exist. This way if it is an
actual duplicate of name, day, time, unit, it will flag and we can correct.
Any help is appreciated.

 

[jimati]

Use the "Find Duplicates Query Wizard" and add the fields that would contain
duplicates. You can set a new form based on that query and view the potential
duplicated records in a list.