"Data Entry" property automatically being set to "Yes"

[Davenz]

Hi

I have a form in access that somehow keeps setting the "Data Entry" property to "Yes"??

If I design the form and change the property back to "No" it works fine, then suddenly it reverts to "Yes"

I have yet to completely rule out the possibility of a user changing this, but see it has highly unlikely.

Has anyone come across this before?

Thanks in advance

David

 

[Davenz]

I've found the problem.

I was opening a "New" form in one area with this code:
Docmd.OpenForm.........., acFormAdd

And in another area of the database without any data mode option.

A user must have hit the "Save" button while having a form opened it the acFormAdd option. This is the equivalent of changing the form property "Data Entry" to "YES"

I have changed my code now to specify the datamode (acFormAdd, acEdit) in every place and this has solved the issue.