Highlighting Duplicate Records in a Continuous Form

[StooPot]

I have a Continuous Form which I have formated to look like an excel spread sheet. I need to highlight the records which have duplicate Delivery Notes.

My fields are as follows

InvCode | DelCode | Ship# | InvNumber | InvDate | DelNote |
-----------------------------------------------------------

I though about writing an expression in Conditional formating e.g.
previous ([DelNote])=[Delnote]

But this does not work! if any body could help it would be much appreciative.

Thank You.....

 

[Frink]

Hallo,

The expression for the conditional formatting should be:
DCount("*","form recordsource table or query name","[DelNote]=" & Me![DelNote]) > 1
if DelNote is Numeric, or
DCount("*","form recordsource table or query name","[DelNote]='" & Me![DelNote] & "'") > 1
if DelNote is a text field.

Since this has to search the whole recordsource for every record it will take ages. You may be able to use recordsetclone within the code to make it quicker, I don't know offhand,

- Frink