Option button Traffic Light System

[penfold1992]

I have set up a group of 3 buttons to select between on my form which works fine.

However I want this to be a bit more visual than it is so Id like to introduce a traffic light system which lights up RED ORANGE or GREEN depending on which one has been checked.

Im not too sure how I would go about achieving this, im not sure if you can import images and hide them or show them depending on the selection or if it requires something further.

could anyone advise me on where to start?

 

[Cronk]

On a continuous form, use conditional formatting to display different colours on various lines depending on the value of a data field.

In a single record form, you can use the OnCurrent event to load a different image depending on the record value.

 

[michaeljryan78]

You can utilize a rectangle and set the fill color in code based in the selection of the frame... if you do not wna tto highlight individual records. If you do want to highlight individual records, then Cronk has the right idea.

 

[penfold1992]

On a continuous form, use conditional formatting to display different colours on various lines depending on the value of a data field.

In a single record form, you can use the OnCurrent event to load a different image depending on the record value.

i have 3 OPTION buttons that decide the color however... option buttons only have "Got Focus, Lost Focus, Mouse Down, Mouse Up, Key Down, Key Up, Key Press"

why dont they have "On Update"... what am I supposed to use to tell when the button has been pressed?

 

[pr2-eugin]

The Option Frame that holds the option buttons have the events you wish to use..