Results 1 to 3 of 3
  1. #1
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407

    SubForm LostFocus issue


    Has anyone else seen the problem with a subform not recognising the gotfocus and lostfocus?
    both options show up in the properties window, but with VBA a breakpoint at the end sub line for both sees nothing, just not seeing it. changing from one subforn to another on same tab page or any tab page for that matter??????

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I think the GotFocus/LostFocus events of object only work if the object does not have any controls that can get focus. This is what I observe by having a subform on one page of tab control and subreport on another. The GotFocus event for the subreport works but not the subform.

    Another interesting behavior. If focus is on the subform tab page when switching to Design view, the subform GotFocus event fires.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    June7's info is dead on, concerning Forms. But the Subform, itself, (not the Form that resides in the Subform Control) is a Control on the Main Form. A Subform Control only shows two events, in the Properties Pane: OnEnter and OnExit. Selecting the Subform Control, itself, try using these two events.

    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-25-2013, 02:52 PM
  2. Form/subform issue
    By ashu.doc in forum Forms
    Replies: 9
    Last Post: 10-09-2012, 04:09 PM
  3. Subform Link Issue
    By danhartman in forum Forms
    Replies: 7
    Last Post: 07-06-2010, 07:14 AM
  4. How to solve this subform issue?
    By Patience in forum Forms
    Replies: 2
    Last Post: 06-28-2010, 07:09 AM
  5. Subform scrolling issue
    By Jerry8989 in forum Forms
    Replies: 4
    Last Post: 12-08-2009, 01:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums