Forum Discussion
Create a traffic light
Hi,
1. Sure, how would the form know what's in the other form if it isn't open?
If you have to show the color with only the Projects form open then you have to either join the underlying tables with a query so that the Status value of Tools is reachable in the Projects form. Or if that's not possible, you have to store the value that triggers the color also in the Projects table.
It's not clear for me what you are describing in your points 2 and 3 or how the two forms or the underlying tables and values should be related to change the color.
BTW You've put the code into the form's After Update event procedure instead of the control's, but I think that would change nothing for your points 2+3.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
Hi,
How do you set the color in the Tools form? If it is done with Conditional Formatting (CF) then you should be able to do a similar thing in the Projects form by referencing the Status control and value of the Tools form in the CF expression.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
Hello Karl,
Sorry but I think I don't understand.
Could you please explain how to do it?The box (with the number 16777215) is a text box added later by me. Opening the conditional formatting, how should I set the values so that in the project mask, as the tool field changes, I get the color recorded in the tool mask at the status field?
Thank you very much.
Hi,
First, it's your turn to answer the question I already asked:
How do you set the color in the Tools form?
With which method, which field or control names, which conditions?
After knowing that, it may be possible to give more concrete instructions for the other form.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEKHello,
sorry for not answering your questions.
I set the colors with conditional formatting; I set 3 rules like this:
Format only cells where the field value is: Equal to: "Condition1" - "Condition2" - "Condition3" and I assigned a different color to each one.
