format current record

[Ivor Williams]

I have a form with a subform. The subform is a continuous form. On the
subform are two fields in which quantities are entered. If the quantities
are the same, I want the ForeColor to be black. If they aren't equal, I want
the ForeColor to be red. I've used the following VBA code to try to
accomplish this:

Private Sub ToSiteQty_AfterUpdate()
If ToSiteQty <> Qty Then ToSiteQty.ForeColor = 255 Else
ToSiteQty.ForeColor = -2147483640
End Sub

This works fine except the ForeColor in ALL the records changes, not just
the current record. Is there a way around this?

Ivor

 

[Guest]

Use conditional formatting on both fields.