Results 1 to 4 of 4
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151

    Trying to show multiple rows from a combo box on form


    I have a feeling this is a matter of some setting that I am missing, but haven't been able to find. Attached are two snapshots of the form. I have put in the colors to make it more obvious what is going on.

    In form view, notice that there are 3 records, but they aren't being displayed together. You have to move to the next screen (2 of 3, and 3 of 3) to view them. I want them to appear like a list on the 1st screen.
    Attached Thumbnails Attached Thumbnails Design view.PNG   Form view.PNG  

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try using Continuous or Datasheet view.
    Last edited by pbaldy; 07-20-2016 at 03:50 PM. Reason: Take out height recommendation, just noticed design view
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  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,016
    And if you go the Continuous View Form route, you'll probably have to decrease the Height of your Form, or you may still only see one Record at a time, without scrolling a great deal!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You made the same mistake I did at first.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Show % of current rows in total rows.
    By redbull in forum Programming
    Replies: 8
    Last Post: 03-29-2016, 09:26 AM
  2. Multiple rows on the same form unlinked
    By Gregory23 in forum Forms
    Replies: 6
    Last Post: 11-26-2015, 11:32 PM
  3. Replies: 3
    Last Post: 10-15-2012, 01:18 PM
  4. Replies: 3
    Last Post: 05-15-2012, 02:51 PM
  5. Replies: 1
    Last Post: 05-03-2012, 04:59 AM

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