Forms with SubForms...Strange Action

[bw]

It took me a long time to get around to composing this request for help, as
it just seems too strange that anyone could provide some help without
looking at any code I might be using. But, I'm going to ask anyway, just in
case something might be obvious to you, that isn't to me.

I have a main form, with four(4) SubForms. When I update the main form,
SubForm1 and SubForm2 are updated via an On Current procedure. SubForm1 and
SubForm2 are Datasheet views. Works fine.

Now when I go to SubForm1 and/or SubForm2, I can select a different record
than the first one chosen. Works fine.

Now the problem. If I click on SubForm3 (anywhere in the form), SubForm1
and SubForm2 go back to the first record, which I don't want. After
correcting the correct records for SubForm1 and/or SubForm2 and click on
SubForm3 AGAIN, the correct records are still retained in SubForm1 and
SubForm2. WHY?

Another twist. If I click on SubForm4 (anywhere in the form), SubForm1 and
SubForm2 do NOT go back to the first record and I can click anywhere in
SubForm3 without SubForm1 and SubForm2 going back to the first record.

I suppose something an my procedures may be causing this, but I have looked
and looked and looked, and can't find anything to cause this.

Any suggestions? How about some suggestions as to how I might test for
what's causing the problem. I'd appreciate any thing you have to offer, no
matter how strange it may be. I'll try anything.

Thanks,
Bernie

 

[bw]

I found the problem, with confirmation from Allen Browne.

SubForm4 has filter code. When I remove this filter, everything works fine.
The links below provided the confirmation I needed, but I'm still not sure
how to fix this.
http://allenbrowne.com/bug-02.html
http://allenbrowne.com/ser-28.html