Access Continuous Forms - control number of records to displayed

Posted on 2007-07-29
Last Modified: 2013-11-28
I have a master/detail in my access form where master is a continuous form and detail is a datasheet:

1. How can I control how many records appear in the master view (currently only 1 but more than one exists)?
2. Is there a way I can create a form with a tab control which display this master/detail form on a tab (with more than one master record) and a simular form on another tab?

So I have tinkered with this for a while to no avail... would appreciate a detailed solution, thx.
Question by:tstreamer
    LVL 39

    Accepted Solution

    1. This is usually done by adjusting the height of the continuous form but you can also do it by modifying the where clause (condition) of the query in the record source.

    2. Not sure what you are describing, but it sounds like you can do what you want with subforms on the tabs.
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now