Further to what Graham has suggested, I create a textbox (usually named
txtDummy) with a height and width of 0 and position it at 0,0 is one of the
form's section for this purpose. The dummy textbox should also not be a tab
stop.
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Graham Mandeno
Sent: August-08-12 10:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Subform LOST FOCUS help
Hi Paul
The trick is to test if the control you want to hide is the active control
and, if so, set the focus somewhere else before you make it invisible (or
disable it).
Something like this:
If Me.ActiveControl.Name = "SubformControlName" Then
Me("SomeOtherControl").SetFocus
Me("SubformControlName").Visible = False
To be a bit more fancy, you could use a tiny transparent command button
named "cmdPark" to take the focus. Then, when the mouse rolls off and you
restore the visibility of the subform, you can check if you are on that
button and set focus back to the subform:
If Me.ActiveControl.Name = "cmdPark" Then Me("SubformControlName ").SetFocus
Make sure cmdPark has TabStop set to "No".
Good luck! :-)
Graham
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar