Checking Values on 2 Subforms for match (1 Viewer)

I have a form with 2 subforms included.


Continuous Subform #1 has SKU's and PRICE's (these are our prices)


Continuous Subform #2 has SKU's and PRICE's (these are supplier prices)


I would like to turn the PRICE field red on Subform #2 if the price does not match the suppliers price when inputted (sometimes they agree a price and then charge a different price when the invoice is sent in weeks later!)



-------------------
Example


Subform #1
ABC £10
DEF £20
GHI £30


Subform #2
ABC £10
DEF £21
GHI £30


DEF £21 should be highlighted in RED

Hi,


Have you tried using Conditional Formatting?


Just curious...

Thanks for the quick reply, Iconditional formatting is my usual goto place, but I don't know how to apply it across 2 subforms and I could't find anything in this forum or searching google on how to do it.

Hi,


I was thinking it might be easier to compare the value in the subform to the value in the other table in your conditional formatting. For example, let's say sub1 is based on table1 and sub2 is based on table2. If you want to highlight sub2, then you'll compare sub2 against table1. For this, you could try using DLookup().


Hope it helps...