form.setfocus not really working

[bbxrider]

I have a main menu form, it is the default form when the db is opened.
from it there is the button to get to form_1 and other forms.


after the work gets done on form_1 I want to return there in case there is more
work to be done. so just before the form_1
exit sub I issue the forms!form_1.set focus
However, I still return to menu form. The form_1 tab is highlighted for it being
in focus but even if I click its tab it still does not display.
I have also tried setting the focus to a control on form_1 but that does not get
it displayed either. so how to get actually displayed and usable as well as having focus?

[June7]

Return to form_1 from where?

I don't like Tabbed Documents - I always set database for Overlapping Windows. Tabbed Documents might be part of the issue.

[Missinglinq]

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)>

[bbxrider]

thanks for the confirming replies, I did switch to overlapping and seems to work fine now, I guess tabbing is helpful/convenient if you are developing with lots of open windows, takes a little more management of them in overlapping. But for sure its the mode to use for a finished product for non tech users

[June7]

I prefer developing with Overlapping Windows because I can view objects side-by-side, such as multiple open tables and queries.