I have a membership database application with MemNo (member number) field string(12).
The Only Text Entry Field is Disabled (not Enabled) which uses MemNo of database field.
In theory the only way to changed the MemNo value is through a routine which I developed to Change from a Temporary member number to permanent member number.
Which updates the dues payment table as well.
However, every once and a while I see the MemNo value is blank or altered from what it should be.
Somehow the MemNo value is changed accidentally when entering another value for different field possibly on another screen.
Is there a way to test that the MemNo field is being altered and alert the user that this is happening?
Other displays of the MemNo is in a simple text label.
Doesn't happen all the time but once in a while.