Form not read only when it use to be

[SteveApa]

Hi All. I just had a user of a frontend backend db tell me that he could edit data in a form - I don't want the user to be able to edit the data in the tabbed subform. This form with a tabbed subform has been read-only for years.
old code:

DoCmd.OpenForm "4d) ViewModify LZ Start - New Version", , , , acFormReadOnly

I modified the code to this and it now works as it did before,
New code:

DoCmd.OpenForm "4d) ViewModify LZ Start - New Version", datamode:=acFormReadOnly

Anyone have any ideas???

Thanks
Steve
Harrisburg, PA

[Welshgasman]

Had an office update?

[Micron]

That person tested with your new syntax and reported that s/he can no longer edit? That would be odd because while the syntax is different, the translation should be the same.
Note that subforms load first, so check your main form code to ensure that it doesn't undo the subform setting.

Methinks that locking the subform control OR setting its recordset type to snapshot OR setting the subform AllowEdits property to False would be better. Sometimes vba alters form/window settings that have been set in design view so I wouldn't always rely on those settings.

[SteveApa]

Yes, the same person tested and was not able to edit after code change.
I agree... should be the same
Nothing else changed except for the code I described
I understand.... and noted.
Thanks...
Steve