Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011
    Posts
    11

    Unanswered: Show ALL records at once in subform

    Hi all-

    I feel lost as I haven't worked with Access in about 10 years and feel like I'm starting all over...

    I want to insert a subform and have that list all data from the relating table (10 or so records with 5 fields each). Seems simple, but I don't know what I'm doing wrong, the subform is only showing the first record.

    Any help is greatly appreciated!

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    To show all of the records you need to switch the subform's Default View to Continuous Forms.

  3. #3
    Join Date
    May 2010
    Posts
    601
    See attached screenshot:
    Attached Thumbnails Attached Thumbnails FormViewContinuous.png  
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  4. #4
    Join Date
    Jun 2011
    Posts
    11

    Thank you!

    I appreciate the help!!

  5. #5
    Join Date
    May 2010
    Posts
    601
    You're welcome.

    Glad we could assist.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •