Here is what bothers me today.
In one form, I have three unbound boxes (named Outmod1 to Outmod3) whom control sources are based on random functions (to simulate small changes for the user). The user toy with those value, lock one or more, before going on further. That is what is intended at first.
So far I use a button with a me.refresh sub attached, and those values change as required.
What doesn't work is the locking part.
I use a check box whose value I test. If True, I set me.Outmod1.locked = true.
But should I hit the button again, the values are modified, even if locked value is set to True.
I don't see a way to lock these values so far.
Any ideas appreciated.
In one form, I have three unbound boxes (named Outmod1 to Outmod3) whom control sources are based on random functions (to simulate small changes for the user). The user toy with those value, lock one or more, before going on further. That is what is intended at first.
So far I use a button with a me.refresh sub attached, and those values change as required.
What doesn't work is the locking part.
I use a check box whose value I test. If True, I set me.Outmod1.locked = true.
But should I hit the button again, the values are modified, even if locked value is set to True.
I don't see a way to lock these values so far.
Any ideas appreciated.
