Lock Checkbox if entry already exists in table.

[spokaneneon]

Hello again! Another thing I would like to do is create a new record, however, query or search a table and see if there is already a new record existing. If there is a record, creating a new one is fine, however I would like that checkbox to be locked with the value from the previous entry. For example, there is a check box in "PIP", I want my form to search for the table and see if there is a match for any other times that has been used, if it has, start a new record, however, lock the option for "PIP" forcing the user to select the next check box in progression. Does this make since?

You guys are amazing, thanks for all you're help so far!
(See picture)