Flag duplicate entries

D

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.
 
J

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.
 
Top