Macro to make record read-only

[Sketchin]

Hello,



I have an invoice form that I would like to add a "Make Read Only" button on. I would basically like to fill in the form, add the items in my sub-form, then lock the record so in the future nobody can come by and accidentally modify it.

Is there a simple macro to do this? Either with a button, or when you exit the form?

Thanks

[June7]

As far as I know, there is no way, in a table, to set a lock on a record against editing. Use form and VBA code to control user interaction with data.