I have a form in which the records can not be edited. At times, certain records need to be changed. I want to create a command button that allows only the selected record to be changed. Any suggestions.
I had a similar way also. For your form go to the Form, Properties, DataTab and set AllowEdits to NO. Next, create a CommandButton, without the wizard, and then go to the Properties of the CommandButton, click on OnEvent then click on CodeBuilder (...) In there you simply put: Me.AllowEdits = True
Oh, in the Form's Properties on the AfterUpdate Event click on the CodeBuilder again and type this: Me.AllowEdits = False
Now when your form opens it can't be Edited until you click on the CommandButton, labeled something like EDIT RECORD. Once you finish that record and tab out of it you automatically go back to a Non-Editable form. OR create a CommandButton to set it to Save the record on demand and set the AllowEdits = False there.
Now you have a couple of ways to do the same thing.