Access Continuous Forms - control number of records to displayed

Posted on 2007-07-29
Medium Priority
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

thenelson earned 2000 total points
ID: 19724773
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.

Expert Comment

ID: 20072417
Forced accept.

EE Admin

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses

862 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