Changing main form properties from the subform

[Eurof]

I am not sure if this is simple or difficult. I have a subform with a quantity column. When I add/change this value, it refects using a total field on the main form. I would like the field to change colour when it becomes negative.

Any ideas

 

[CajunCenturion]

Is the total field in a continuous form? If so, then I suggest that you take a look into ConditionalFormatting.

If not, then you might want to consider simply changing the backcolor inside an If statement used the Change event of that textbox.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Eurof]

Initially your conditional formatting looked the best option, however, as I said the text box is based on the sum of the quantity, but I wanted the text box to be red if it was greater that the value in another text box.

Thinking about you change event, I cannot get this to fire. I am not sure why, is it because the sub form has focus.

 

[CajunCenturion]

That could be. Have you tried accessing the control, setting the properties accordingly, directly from the subform

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein