How to set background color of textbox which is sum of two other textboxes based on a query

[FL0XN0X]

Hi,

I have got a query on which I have built a continuos form. The form contains textboxes which values I need to add. Thus, eg. textbox1 holds '1', textbox2 holds '5', so I create a textbox3 that is the sum of both textboxes 1 en 2, resulting in '6'. Now I need to set conditional formatting on the textbox; ie. if the extbox value exceeds a certain threshold, the backcoler property must change.

Code may look like:

If me.textbox3 > threshold
then textbox3.backcolor= RGB(255,0,0)
Else textbox3.backcolor= RGB(0,255,0)
End If

But where do I need to put the code since the query first need to be ended ...

Thank you in advance.
Kind regards,
Bart

[June7]

Use Conditional Formatting, not VBA.

[FL0XN0X]

Thnx !!! I just found the conditional formatting !!