To be honest, I'm having trouble following all of your explanation, but a Form cannot receive Focus if there are any Controls on the Form that can receive Focus.
FWIW, I strongly agree with June7 vis-à-vis the use of the Tabbed Documents for the Document Window Option! This option is really designed to provide a 'plug-and-play' type of capability to Access for people with little experience in or desire to learn programming. It's really meant to be used by clicking on the Tab of the Form you want to open.
For things like moving from one Form to another Form, using code, you really need to switch the option to Overlapping Windows; it's the very first thing I do when creating a new file.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007