Results 1 to 3 of 3
  1. #1
    Fionn is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    13

    Form won't scroll because focus is on a sub form.

    Hi,
    I have a form in access which contains a number of sub forms in which information is to be entered thus the focus is on the textboxes in these forms. The problem is in order to scroll down to the other sub-forms contained in the main form the focus must be set to the main form. So in order to scroll I must click somewhere on the main form or use the scroll bar. This is quite annoying and I have not been able to find anything on google on how to fix this problem. Does anyone have any ideas? I was thinking maybe if there was some vba code for an On Scroll event but haven't been able to find anything.
    Thanks.

    Edit: I have tried Mainform.SetFocus in the OnMouseWheel event of the subforms but it doesn't work.
    Edit1: Ok so Mainform.SometextBox.setfocus works but now it becomes very annoying while filling in forms as the current textbox being filled is deselected whenever you scroll so If anyone knows a better way of doing this I would appreciate it.

  2. #2
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    First things that popped into my head:
    1) Use tabs instead of the mouse?
    2) Use a control on Subform A to jump the screen and cursor position to Subform B and vice versa?

  3. #3
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Another way that I've seen mentioned recently is to have a hidden control on subform A, and when the user tabs to that control, the onFocus event of that hidden control jumps the focus to the first control of the next subform.

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

Similar Threads

  1. scroll bar in form
    By johnnyc11 in forum Forms
    Replies: 5
    Last Post: 06-07-2013, 07:30 AM
  2. Replies: 1
    Last Post: 02-29-2012, 09:38 AM
  3. Replies: 11
    Last Post: 01-26-2012, 01:22 PM
  4. PDF and form scroll bar issue
    By GraemeG in forum Forms
    Replies: 4
    Last Post: 04-03-2011, 04:28 PM
  5. Replies: 1
    Last Post: 12-10-2009, 09:58 PM

Tags for this Thread

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