Subform on enter event fires when the form loads

[sneuberg]

I have a form where all of the controls including a sub form were inadvertently place in the header of the form. I wanted to anchor the sub form to the bottom of the form and so I moved the controls from the header to the detail section. Now the On Enter event of the sub form fires when the form is loaded. This isn’t normal. I created a simple form with a sub form from scratch and the sub form On Enter event didn’t fire when the form was load. I experimented with this simple form and moved the text box of the parent table to the form header. As expected the On Enter event fired when the form was loaded. Not so expected was that this still occurred when I moved the textbox back to the detail section. By moving I mean dragging, and cutting and pasting. I’ve tried both. The form can’t seem to forgive and forget. I don’t want to recreate this form from scratch. Any suggestions?

[June7]

Check the TabOrder property of the controls.

[Missinglinq]

Check the TabOrder property of the controls.

Yes, if the Subform Control is the first Tab Stop you'll see this behavior.

Linq ;0)>

[sneuberg]

Sorry, I thought I posted a thank you note yesterday, but somehow it didn't get posted. The tab stop was the problem. Mucho gracias, vielen Dank, and thank you very much.