What happens with forms after windows is unlocked

[Dan Neely]

I have several subforms set to function for data entry only (edits,
deletes, navigation disabled; additions, data entry enabled).
Everything works fine until I lock and unlock my computer. Several
seconds after the computer is unlocked both subforms select and
display an existing record. In one case it's the first record in the
table, in the other a record in the middle and I can't figure out
what's special about it. I've tried sticking event handlers on what I
though were the most like events to blame but all I've managed to
figure out is that whatever is going on is occurring is happening
prior to the subforms OnCurrent events.

 

[Dan Neely]

I have several subforms set to function for data entry only (edits,
deletes, navigation disabled; additions, data entry enabled).
Everything works fine until I lock and unlock my computer. Several
seconds after the computer is unlocked both subforms select and
display an existing record. In one case it's the first record in the
table, in the other a record in the middle and I can't figure out
what's special about it. I've tried sticking event handlers on what I
though were the most like events to blame but all I've managed to
figure out is that whatever is going on is occurring is happening
prior to the subforms OnCurrent events.

After sticking event handlers on every form event possible, I've found
that the only event firing before the selection is made is the Apply
Filter event. This is happening despite the form being set to Allow
FiIters = no, Data Entry = Yes, and no value for Filter. On one of
the three subforms where this behavior is a problem I was able to stop
it by setting Cancel = True in the Apply Filter event. The other two
still selected a record for display (without firing any additional
events) as soon as the Apply Filter event was exited.


It also only happens with subforms. If I open one of the subforms on
its own, nothing happens.


Any ideas on how to stop the remaining two forms from doing this?