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.