Conditional Formatting Continuous Form based on 2 fields (1 Viewer)

[Danick]

I'm trying to highlight a field with duplicate values in a continuous form but only when that field and another field are different.
I've tried various combinations of the following code, but can't get it work

DCount("*","TableName","[SN]='" & [txtSN] & "' AND [ID]<>" & [ID])>0

This is what it's supposed to look like in the end.

 

[Gasman]

How is Access meant to know which ID you are talking about?
To me it looks like you are comparing the field ID with the fieldID, which of course would always be the same?

You differentiate for SN and txtSN, why not the form control ID ?

 

[Danick]

How is Access meant to know which ID you are talking about?

Yes this is the problem. I can't figure out how Access can differentiate these fields.
Basically, it should look at all SNs that are identical and then only highlight SNs that have different IDs.

 

[Gasman]

What is the ID meant to be for those ABC's that you are checking?
Why can't you use txtID as you did for SN?

 

[Danick]

What is the ID meant to be for those ABC's that you are checking?
Why can't you use txtID as you did for SN?

I picked an ID field that repeats itself for simplicity. But it could very well be a PO number or a Received Date field.
There will be many records of a SN that came in on a Received date. So I don't need to highlight any of those SNs.
However, it that SN is repeated on a different received date, then I'd like to highlight those SNs.

 

[Gasman]

You still need to compare against the form control value though, surely?
Regardless of what field you use?