I'm not sure if this is possible. I want to highlight a row in a datasheet view form if the following situation exists. The form has tblEstimateNotes as its record source.
There are two tables. One is named tblCustomerAutoNotes and the other one is named tblEstimateNotes. If any one value of fieldname in a row in tblEstimateNotes MATCHES the value of fieldname in tblCustomerAutoNotes then make the background color of that row a light green.