Lock Specific Records

[GendoPose]

Hi all,

I want to lock an individual record when a certain check box is ticked so it can't be edited again. I've tried setting the form to read only when this check box is ticked on the form OnCurrent event, but this locked every record and I had to remove the code to untick the check box and be able to edit the record again.

Any ideas?

Thanks guys

 

[JHB]

Set the form's property Allow Edit to Yes/No in the form's OnCurrent event, depending on your check box.

 

[GendoPose]

Ok I just completely reentered the code from scratch and it's now working, thanks.