I
Ian Smith
I often show memo fields in a two or three line field and
pop-up a form in an on-click event to display of edit the
memo full screen.
It nearly always works, but in a couple of instances, I've
encountered errors where the pop-up can't update the
field 'cause the main form has the record locked.
Before opening the pop-up, the main form does a refresh if
the record is dirty to avoid this very problem.
A user referred me to a record that demonstrates the
problem (others behave properly). And I've built a very
simple form to reproduce the problem. It is clear that it
is the main form holding the lock because if I move that
form off the record while the popup is open, the update
succeeds.
What action must I take in the main form to give the pup-
up an unlocked record?
pop-up a form in an on-click event to display of edit the
memo full screen.
It nearly always works, but in a couple of instances, I've
encountered errors where the pop-up can't update the
field 'cause the main form has the record locked.
Before opening the pop-up, the main form does a refresh if
the record is dirty to avoid this very problem.
A user referred me to a record that demonstrates the
problem (others behave properly). And I've built a very
simple form to reproduce the problem. It is clear that it
is the main form holding the lock because if I move that
form off the record while the popup is open, the update
succeeds.
What action must I take in the main form to give the pup-
up an unlocked record?