Help with formatting subforms

[Jim W]

I have a main form with 4 subforms. The subforms a setup in columns kinda like excel. Eack subform is displaying data. What I want to do in compare the data in subform 2, 3, 4 to the data in subform 1 and if different using the conditional format change the color of the fields. How do I code a conditional format from subform to subform?

Jim

 

[scouser]

Format

I know you can do it his way (see attached).
You may want to write some conditional code using VB instead.

What are you looking to acheive?

Example

If .OrderClosed = -1 Then
Me.OrderStatus.ForeColor = 255 ' Control colour
Me.OrderStatus.BackColor = 0    ' Control colour

Else IF
If .OrderClosed = 0 Then
Me.OrderStatus.ForeColor = 0 ' Control colour
Me.OrderStatus.BackColor = 255    ' Control colour

Something like that...........

Hope it helps.....