B
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
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