Automatic checkbox based on value entered in form

[w00tage19]

I've created a database that keeps track of patient info, and one of the fields is systolic blood pressure or SBP. I have another field that is a yes/no checkbox called "is SBP less than 90?" Is there a way to have that checkbox automatically be checked in the table when the SBP fits the condition? I wrote a module function that can do it for reports, but it would be nice if the checkbox can be checked automatically in the table when a user enters all of the info on the form. It seems like there should be an easy solution to this problem, but I can't seem to find it (I've only been using Access for like a week, but I'm a decent programmer, so a solution that involves writing code is fine by me). Any help would be appreciated! Thanks.

[ConneXionLost]

My advice would be: "Don't store calculated fields in a table."

Cheers,

[NoellaG]

Hi,

I concur with conneXionLost, but you could add a calculated check field on your form with as control source :
= ([SBP] <90)