New Record in Form, Subform

[iamnu]

I have a Mainform linked to a Subform by ProviderID.
The Mainform has three Combo Boxes containing AcctID, PayeeID, and
CoNameID respectively, and all have a "On Not in list" event procedure
to add new values to the respective tables. All other controls on the
main form have the Tab Stop property set at "No".

When I move through the Mainform and Subform to view or edit data
using Tab, ctrlTab, Enter, etc; everything works as it should.

The problem is when I enter NEW values into the Combo Boxes. Upon
pressing the Enter key, the Focus is then put on the first field of
the Subform in the LAST record of the Mainform.

Is this normal behavior?

If I simply ctrlTab to the Mainform, then go (Page Up or Page Down) to
the New Mainform record I just created, I can then enter values in the
new Subform record as necessary.

Why, when I enter new values on the Mainform does the Enter key NOT
take me to the appropriate record in the Subform?

Thanks,
Bernie

 

[iamnu]

I have a Mainform linked to a Subform by ProviderID.
The Mainform has three Combo Boxes containing AcctID, PayeeID, and
CoNameID respectively, and all have a "On Not in list" event procedure
to add new values to the respective tables.  All other controls on the
main form have the Tab Stop property set at "No".

When I move through the Mainform and Subform to view or edit data
using Tab, ctrlTab, Enter, etc; everything works as it should.

The problem is when I enter NEW values into the Combo Boxes.  Upon
pressing the Enter key, the Focus is then put on the first field of
the Subform in the LAST record of the Mainform.

Is this normal behavior?

If I simply ctrlTab to the Mainform, then go (Page Up or Page Down) to
the New Mainform record I just created, I can then enter values in the
new Subform record as necessary.

Why, when I enter new values on the Mainform does the Enter key NOT
take me to the appropriate record in the Subform?

Thanks,
Bernie

Hooray! I found the problem.
I had inexplicably added a requery to the AfterUpdate event.
After removing it, everything is working fine now.

Thought some may be interested in this resolution.
Bernie