Solved Creating four textboxes with different colours relating to a lookup table fields (1 Viewer)

[Sam Summers]

Hi everyone,

All i am trying to create four boxes on a form, each with a different colour (Green, Blue, Grey and Purple).

The user will select the current colour relating to the item which will be the current colour code for the period.

I have created a 'Colour' Table but currently do not know how to implement this.

Any pointers would be great.

Many thanks in advance

 

[mike60smart]

Hi Sam

What is supposed to happen when the user clicks in the Green Box?

 

[Sam Summers]

Hi Sam

What is supposed to happen when the user clicks in the Green Box?

Hi Mike, its just stored in the record until the user selects a new colour for the next period

 

[mike60smart]

Hi Sam
So the 4 Colour Boxes are on a Main Form
Then a Subform has a number of records.
When the user selects a Colour it applies that Colour to the Current Record in the Subform?

 

[arnelgp]

demo of using color table

 

[Sam Summers]

Hi Mike and Arnel i should be able to create what i want from Arnel's attachment Thank you both very much.
I will post when i have solved it

 

[Pat Hartman]

Since you only need a single value for color, the options are mutually exclusive. Therefore, instead of using four separate controls, you need to use ONE control with four choices. You can use a combo which won't be pretty or you can use an option group if the colors are fixed.

 

[Sam Summers]

Hi All of you and thank you Pat too.
I went with Arnels method as the user has to see the colour to select the current colour where the period (6 months usually) may vary at each end of its implementation.
So all i used was the colours with no fixed periods.

Thank you all again for your help as always!

 

[arnelgp]

Thank you all again for your help as always!

what happend to your Avatar? is it a symbol of purity?

 

[Sam Summers]

what happend to your Avatar? is it a symbol of purity?

Ha Ha, no it was when i was in the Sahara

 

[arnelgp]

no it was when i was in the Sahara

a grain of sand i suppose...

 

[Pat Hartman]

I guess you don't know what an option group is. We could have explained it. Now you will always have four fields to check rather than one.

 

[arnelgp]

check rather than one

there is only 1 field and is bound to Option group.

 

[Pat Hartman]

Thank you for the clarification. I couldn't tell that from

a grain of sand i suppose...