[MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

 

I have a form named         f_PremCollFormSetup

I have a field in that form called     CTICOBRACount

 

When a person enters a value into  CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called  CTICRUHealth  and CTICRUDental to a value of 1

 

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

 

I am having a hard time figuring out where the best place to put this.  I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

 

Do I use iff or If then… 

 

It has been a while since I had to add programming.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net