Locking record on form 2

[njwcad]

Can anyone help!

I have a table based form which I would like to lock when all boxes have been filled in / completed. I have tried doing this through Macros and have spent two days continually tweaking the Macro to get it right but realised that there may be an easy way to do this such as some visual basic code. In essence, every time I open a record that has been previously locked an uneditable and every time I open a new version of form or a record that has not been locked I want it to be editable. I'm happy to achieve this through a completed yes / no completion box.

Hope this makes sense
Thanks

 

[TheAceMan1]

How are ya njwcad . . .

With a [blue]Checkbox in the table[/blue] of interest and included in the forms [blue]RecordSource[/blue], in the forms [purple]OnCurrent[/purple] event:

[blue]   Me.AllowEdits = Not Me![purple][b]CheckboxName[/b][/purple][/blue]

See Ya! . . . . . .

 

[Ed2020]

Now that's a nice simple solution. I wouldn't have thought of that. Have a star!

Ed Metcalfe.

Please do not feed the trolls.....

 

[njwcad]

Thanks

The usual speedyu response and excellent help. I'll let you know how it goes


Paul