I am trying to prevent changes to specific controls when a record is not new to prevent accidental editing and to have more control over when an edit occurs. Is there a way to check on a form if the record is new and if not, locked and disable a series of controls along with changing their background to be grayed out to represent the fact they cant be used? All the controls on the form I wish to "lock" are text boxes with the exception of one which is a combo if that matters.
Would I use
Would I use
Me.NewRecord
to check if the record is new then re-enable the controls then if it returns false, disable them?