Click on a subfrom and the current event of anothr subform fires

[Mark A. Sam]

This is AccessXp, but had been a problem on A97 also, at least on this app.

Mainform1 has three subforms, SubA, SubB, and SubC.

SubB is linked to SubA and the LinkMasterFields is a textbox on MainForm1.

SubC has no relationship with SubA and it has a LinkMasterFields which is a
Combobox on Mainform1.

When I click on a textbox in either SubB or SubC, the current event on SubA
fires. This is a problem, because I need to requery a combobox on Mainform1
from the current event on SubA. When I add the requery method then click on
SubB or SubC, SubA's Current event fires over and over.

The combo being requeried it the LinkMasterFields of SubC, but I don't know
that it matters.

Is there a way to prevent this?

God Bless,

Mark A. Sam