Set Focus on Form control - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Set Focus on Form control

Richard Pitassy

3 years ago

I have a Main Menu form with a number of buttons that take the user to other forms and reports ("targets").  In most cases, the Main Menu remains open behind the Target.
When the user closes the Target, I want the focus to return to a Search text box on the Main Menu.  I would like to avoid having to add code to the Close buttons on each Target to explicitly set the focus to the Main Menu search box or requery the Menu, etc.
On the Main Menu, I have tried to set the On Got Focus and  On Current events to set the focus on the Search text box but that doesn't work.
Seems to me that when the Main Menu becomes the only open form there must be an event/property/code that can be used to set the focus on my Search box control.  Any ideas greatly appreciated.  Thanks.

Kevin Yip @Reply

3 years ago

A form's GotFocus event doesn't run if the form has controls on it. It only runs if the form has no controls (blank form). This may sound puzzling, but can be easily demonstrated. Click on a textbox, then click on a blank part of the form. You see the cursor is still inside the textbox. The textbox doesn't lose focus (by design) if you click on the form. That's why the form can't get focus if it has controls on it.

Regarding your original goal, I suggest you make an invisible form with a timer that checks if the main menu is the only form open ( Forms.Count = 1 And Forms(0).Name = "MainMenuForm" ). If so, set focus accordingly.

	Richard Pitassy OP @Reply 3 years ago
Thanks Kevin. I'll give that a try.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View