Results 1 to 4 of 4
  1. #1
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112

    Where's the focus with form, subform, and listbox

    Hello,
    I have a problem that relates to scrollbars, mouse wheels, and -- I think-- where the focus is.

    I have a form for some information to be entered, and then a subform based on another table, where more info is entered. The subform has only one field -- a listbox where multiple selections will be made, too many options to show at one time. So, the user must be able to scroll/wheel down as she checks off items in the list.

    The problem is moving down through these options in the listbox. The wheel and scroll bar do not work. Thinking the problem was where the "focus" is, I suggested to the user that she click on the subform's vertical bar (with arrow and pencil) to get the focus into the subform and that the wheel and scroll bar should then work. But it doesn't always! And sometime you wheel several times and then it works. And sometimes (the user says) the vertical bar doesn't even show.

    And, now I don't know if I want a scroll bar on the subform or the listbox! or, how to do one or both.

    Any help would be appreciated! I am in a mess.
    Thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,973
    Control or object must have focus for the scroll bar to work. Scroll bar doesn't show unless there are more records than can be displayed.
    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
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    I think you automaticly get a scrollbar when you hit 16 rows. I dont see any option to disable it.
    But it sounds like a bug. You might wanna try creating a new listbox and see how that behaves.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    It may be that all of the available records are not loaded into memory. Dynasets will retrieve some of the records and continue to receive additional records as the user demands more records to be viewed.

    One option may be to change the recorsource/rowsource type to Snapshot. However, snapshots are not updatable,where dynasets are updateable.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-31-2015, 09:03 PM
  2. Requery Main Form, Keep Focus on Subform
    By burrina in forum Forms
    Replies: 8
    Last Post: 11-21-2012, 03:50 AM
  3. Move Focus From Subform To Main Form
    By burrina in forum Forms
    Replies: 2
    Last Post: 11-18-2012, 03:09 AM
  4. Set Focus to Next ListBox Item
    By burrina in forum Forms
    Replies: 2
    Last Post: 11-10-2012, 08:25 PM
  5. Replies: 3
    Last Post: 10-09-2012, 11:58 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