VBA is permanently changing my properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've noticed that changes by VBA for a form property (such as the lock
property) are being saved with the form. I'm NOT doing a docmd.save on the
form, yet it seems it is "automatically" saving changes.

I have my form set to Allow Design Changes - Design View Only. Any
suggestions?

Thanks,
Leif
 
Leif said:
I've noticed that changes by VBA for a form property (such as the lock
property) are being saved with the form. I'm NOT doing a docmd.save
on the form, yet it seems it is "automatically" saving changes.

I have my form set to Allow Design Changes - Design View Only. Any
suggestions?
Click to expand...

Can you create a reproducible scenario? Some properties get saved
automatically, like the Filter and OrderBy properties, but I can't make
the Locked property do that even if I click the Save button.
 
I was not able to reproduce the problem. However, I don't understand how
these properties were changed. I've added code on the form load event to set
the locked property of the problem fields to TRUE. Hopefully that will
override whatever caused the problem in the past.

Regards,
Leif
 
Back
Top