Check box question

[vad60]

I have a form called fhd2_Help_Desk. I want to put a check box on it that when checked it will update another field and if unchecked to update that field with a different value.
I added a check box called Critical and the control source is a field called critical. It is a yes/no field and the default value is false. Then on the same form is a field called Priority with it default value set at "Normal". If a user checks Critical I want to change the value of Priority to HIGH. If the critical chack box is unchecked then I want the value of priority to change back to Normal.
My problem is that on the on click property I set it to run a macro to change Priority to HIGH. But if unchecked it runs the same macro and the Priority stays set to High.
Thanks for any help anyone can give me.

 

[boblarson]

Don't use the click event of the checkbox. If you do, the value hasn't changed yet. Use the After Update event.

 

[The_Doc_Man]

Not that I think it makes a huge wad of difference, but this almost sounds like a radio-button function.

 

[boblarson]

Not that I think it makes a huge wad of difference, but this almost sounds like a radio-button function.

Good point - If an option group were used, you could have 3 options:
1. Critical
2. High
3. Normal

and just store the value of the option group.

 

[vad60]

I created an Option Grp. Two buttons one YES(True) and one NO(False) and false being my default What I want to happen is this, when yes is selected update the Priority field to HIGH. If NO is selected, in case the user marked it critical by mistake, to change the value of priority back to Normal. I don't need for the Priority field to be part of the Option grp. The default value of the Critical field is set to NO, and Priority is set to NORMAL. So most of the time there will be no change to these fields.