I am trying to get this to work in a sub form, to highlight the customers number in red and yellow background but its not working, the field in a text field
DCount("*","Customer_main","[Service_Number]=" & Chr(34) & [Service_Number] & Chr(34))>1
DCount("*","Customer_main","[Service_Number]=" & Chr(34) & [Service_Number] & Chr(34))>1