Highlight Duplicates

[Gismo]

Hi all, please could you assist? I want to highlight duplicated records. The form is from one table only. I dont want to use a linked table as this form is uneatable. I tried to use conditional as an expression but not sure if I am using the correct criteria. I used a query to filter only duplicated record, I then used expression in conditional
[Duplicate SB's]![SBNo]

 

[isladogs]

Try this method. Add a Boolean field and call it Dupe or similar.
Identify your duplicates and use an update query to set Dupe=True for those records.

In your form, add CF based on expression Dupe=True.

Alternatively what not show just the duplicate records

 

[Gismo]

I did this but my update query does not work as i requires an uneatable query when I link the table with the query that displays the duplicates

 

[isladogs]

Two possible solutions
1. Make sure your update query has Unique Records =Yes. In SQL that is UPDATE DISTINCTROW.

That normally works but if still read only then
2. Create a temp table of your duplicate values using a make table query.
Then create your update query based on the two tables. You may still need to do the change mentioned above as well