Hi!
I have bound forms all over my database and it's causing some significant unwanted updates every now and then; even when users does not intend to.
I have discovered that the two main culprits so far are the:
1. Escape key (when it can't detect dirty event.)
2. Refresh key (when user press it, whatever is in the form whether it's filled out or not, it will be updated automatically which is a major pain.)
I have already trapped my Escape Key and as of now, I intend to
trap Refresh key also.
My question:
A. Do trapping both of that keys on selected forms would somehow backfire on the integrity,function and overall stability of my database in the long run?
B. Is there any other way to secure entry and tighten up control over update and saving process while preventing accidental unwanted updates?
I can smell unbound forms, but i want answers for bound forms only if possible.
I have bound forms all over my database and it's causing some significant unwanted updates every now and then; even when users does not intend to.
I have discovered that the two main culprits so far are the:
1. Escape key (when it can't detect dirty event.)
2. Refresh key (when user press it, whatever is in the form whether it's filled out or not, it will be updated automatically which is a major pain.)
I have already trapped my Escape Key and as of now, I intend to
trap Refresh key also.
My question:
A. Do trapping both of that keys on selected forms would somehow backfire on the integrity,function and overall stability of my database in the long run?
B. Is there any other way to secure entry and tighten up control over update and saving process while preventing accidental unwanted updates?
I can smell unbound forms, but i want answers for bound forms only if possible.