Button to Change Form from View to Edit

[danielw.au]

Hi Everyone,

I have created a form in Access 2010 that opens in view only mode. I do this as I do not want data being changed in error. There are times when the user may need to edit some data on the form.

Can anyone suggest a way to place an "Edit" button on the form that allows the user to edit the current record? I thought about creating two seperate forms, but I really don't want to maintain two of them.

Kind Regards

Daniel

 

[JHB]

What do you mean by "view only mode"?
If you don't want the form open so people can change the data, the set the form's property Allow edits to no, and then change in to yes when the button is clicked. Look in the Help file for sample code.