I have AllowEdits set to False on my form. To avoid unwanted changes in the form I have created a button to allow editing only when it is pressed and it works great.
Now I'm wondering if there is a way to make my button turn into a Stop Editing button so that people can click it when they are done making changes to the form.
Code for Edit button:
Now I'm wondering if there is a way to make my button turn into a Stop Editing button so that people can click it when they are done making changes to the form.
Code for Edit button:
Code:
Private Sub btn_Edit_Click() Me.AllowEdits = True Me.btn_Edit.Caption = "Editing" End Sub Private Sub Form_Current() Me.AllowEdits = False Me.btn_Edit.Caption = "Edit" End Sub
Comment