Make entries uneditable based on checkbox

[acehowell]

I have a secured form and i am looking to put a checkbox, or combo box for completed once checked or yes is selected then entries for that record are locked. I want to be able to enter information, leave checkbox unchecked and be able to go back and edit information. Once i hit add new button the fields for the next entry should be editable. Hope i have explained myself enough. Thanks.

 

[KenHigg]

I think you should be able to put code in the oncurrent event of the form that evaluates this 'check box' to turn controls 'on' and 'off'. And set the default to false. Of course you need to add a 'completed' field in the table to store the value / status for each record.... Hope this makes sense...