roxys 0 Newbie Poster

Hello,

I want to let access fill in a checkbox automatically based on the value of another field in the same table.

I have a student course registration system in access, and I have a table of Marks that have a mark field, diploma field and the student_id, that I enter the marks that the student gets for an exam. The diploma field is a checkbox.

And I want to let the diploma field checkbox be filled in automatically when I enter the mark field, and if the mark field value is more than 5.5.

Can anyone help me with that?

Thanks