I need to find duplicate records in my Tables by Surname and Forename and on my Form (Subform which is Datasheet) I want to colour these duplicate records yellow. Or just colour the SURNAME field yellow if possible?
Create a new query that groups by the Surname and Forename and counts the Surname.
Add this new query to the query that is the source of the form and link by Surname and Forename. Add the count field to the query.
Add the count field to the form and use it to change the back color (if me.CountField > 1 then me.SurnameField.backcolor = yellow or use conditional formatting that checks the value of the Count Field).