Check a checkbox on main form if record exists in second form
I have a form bound to a table that has a checkbox. I want this checkbox to be true if any record exists in an unrelated table. Both tables are "related" via a commonly named field named "JobN". This field is a number field. How can I do this?