Disable checkbox on a form

[caffe]

I have an Access database where managers can search records using a form. The data is in an SQL database and tables are linked in to Access. One of the items on the form is a check box called Delete, so a manager can mark a record to not process.

However, if the record has already processed (which is a -1 for a check stored in another field called Sent), I need to either disable or hide the Delete checkbox. There have been instances where the manager "didn't notice" the Sent check and clicked Delete, and then questioned why the item processed.

Any suggestions greatly appreciated!!

[weekend00]

check in after_update event.

[caffe]

Thanks for pointing me in the right direction! I was trying to disable or hide the checkbox, what I needed was to make sure the users checked the box when appropriate. Here's the vba I used in the AfterUpdate:

   If Forms![management]![DeleteMark] = Forms![management]![Sent] Then MsgBox ("YOU CANNOT DELETE A PAYMENT THAT HAS ALREADY PROCESSED!")
    If Forms![management]![DeleteMark] = Forms![management]![Sent] Then DoCmd.RunMacro "ClearDeleteMark"

The ClearDeleteMark macro sets the DeleteMark field back to Null.