I want to "lock" records as soon as the "add" button is pressed, and the only way to unlock the records is to press a button (or any other object on the form) and once the record is locked all information is grayed out and not available to edit.
Any time I google lock records in access, I get the generic record locking options about optimistic/pessimistic locking.