Hello,
My first post so apologies if I get things wrong.
I wish to present a form linked to a table of record eg, Customers. When the form is first presented I want the records locked to prevent any accidental changes. On the form is an edit button which the user can press to make changes to a record.
I have used the Form Property “Allow Modifications” set to “No” on the Data tab to initially present the form such that the user cannot change the data. The edit button is linked to this macro:
Sub ChangeFormReadWrite(oEvent)
oForm = oEvent.Source.Model.Parent
MRI oForm
oForm.setPropertyValue(“AllowUpdates”, True)
MRI oForm
End Sub
MRI shows me that the form property does change when the button is pressed, however I still cannot edit the date.
If I toggle the setting manually it works as expected.
Can anyone tell me what I am missing please?
Many thanks
Hans