Error 2110 Tabbing between subforms

[mikem]

I got my form to tab between subforms just like I want. But I broke something else. My goal was to simply to tab from the main form to the subforms and back.



it successfully starts on the main form. After Buy/Sell, jumps to the first record in frmShortScoresP. Then it works down through all 4 subforms following the arrows. Then it jumps back to the main form. Then to the Trade Info tab.

All that seems to work great. then when i add a new record, I get the 2110 Error. But I'm not on frmShortScoresM when that happens. I'm on the main form... I think.

I use the same code to move between each subform. I'm on the Score filed, when i get to the last record, it tabs to the next subform.

Any idea what I'm doing wrong?

[mikem]

oops
I figured it out.
I hade to switch the sequence of my 2 statements in the if-then
I needed to move the focus back to the first record on the subform before I left the subform
if I didn't, then came back to the subform, then the if statement was true and it would try to execute again