Yea I had tried that originally and it actually has the same effect as did with the code... it just blanks the subform fields except for the ones I mentioned earlier and focuses back on the first field of the subform.@gasman
I wish I could say it's done by some very clever coding but I would be lying.
There is no trickery and indeed no code.
If you look at the tab order for the main form, the subform control precedes the hide subform button so it tabs from subform to that button
Sorry I got led astray by your key up code
As stated above, you don't need any code in the last control on your subform.
Remove everything you've done for this issue.
Just make sure the tab order has subform before lab defect textbox and it should tab correctly
I have the tab orders to go through the top main form fields (1 through 5) and it tabs to the subform correctly as it is next in the tab order (6) but it will not tab to the next tab number on the main form (7).
I know it is totally easy to solve this by having everyone use Ctrl+Tab which of course works but I don't expect the users to remember that as I have enough trouble getting them to fill out fields correctly.