Read only forms with an edit button

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello group:

I have a form in which I set that is read only, but I have
been asked to add an edit button so that people can add
and change the data as needed. Here is the problem, the
macro and button work, until the form is closed and re-
opened...then the edit button is read only too.How do I
correct this problem?

Thanks,

James
 
Can you tell me how you created the button to switch from non-edit mode to
edit mode. Thanks.
 
Set the form's AllowEdits, AllowAdditions and AllowDeletions properties to
false, then put code like:

Me.AllowEdits = True
Me.AllowAdditions = True
Me.AllowDeletions = True

when you want to allow the users to change the data.
 
Back
Top