Updating a checkbox depending on a value calculated in another field on the same form

[lodgey47]

Hi,

I have a problem that I need help with!

I'm trying to find a way of automatically placing a 'tick' in a check box depending on a value in another field on the same form.

The checkbox I want to update is called 'conditions met' and the other field on the form is called 'Total Score' (which is the total of 6 other fields on the form) What I want to do is if the 'Total Score' field is greater than 30 then put a tick in the 'conditions met' checkbox, if it isn't then leave 'unticked'.

I've tried a couple of suggestions I've found on here but can't seem to get it to work. Any help would be greatly appreciated. Thanks in advance.

 

[pbaldy]

I think it's a mistake to try to store and maintain that field. It would violate normalization rules, and there's really no need for it. On forms and reports, have a checkbox with a control source like:

=IIf(TotalScore>30,True,False)

 

[lodgey47]

Thanks Paul. That works exactly as I want it!

 

[pbaldy]

No problem! I think you'll be happier in the long run.