Forum Discussion

MarcoCoffee's avatar
MarcoCoffee
Copper Contributor
Sep 27, 2023

Create a traffic light

Hello everyone,
I would like to know if it is possible to create a kind of traffic light that reflects a condition recorded in another mask. The images below will help in the explanation.

Therefore, I would like to see that in the project mask, as the tool to be used changes, the color in the box below (where there is currently a number) also changes; which should be the same as the color corresponding to the tool recorded in the tool mask.

 

Thanks for the help.

access
  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    Sep 28, 2023

    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

     

    • MarcoCoffee's avatar
      MarcoCoffee
      Copper Contributor
      Sep 28, 2023

      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.

Resources