Second Subform not showing all records

Posted on 2014-02-23
Medium Priority
Last Modified: 2014-02-23
I have a form that I'm using to enter attendance records.  On the same form, I have two subforms, one to show each new record that I've entered (All students entered in descending order, showing time of class and student's name), and one to show a count (totals query) for each class as a cross-check.

For some reason, the second subform is only showing one record, one grouped class and the total students.

Any idea why this might be happening?
Question by:BBlu
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39880933
check the record source of the 2nd subform.
LVL 20

Expert Comment

ID: 39880954
Make sure the second subform is not set to view only SINGLE RECORD.

Scott C

Author Comment

ID: 39880955
Hey Rey-
The source is the form of the query that I want.  If I open the form by itself, it shows all of the records.
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.


Author Comment

ID: 39880958
Hello Scott,
what option would the "Single Record" be under?  I don't see that.
LVL 29

Accepted Solution

IrogSinta earned 1200 total points
ID: 39881079
I think Scott means that the DefaultView property under the Format tab of the Property Sheet should not be set to "Single Form."  I would also make sure that the LinkMasterFields and LinkChildFields property under the Data tab of the subform are not set to anything.


Author Closing Comment

ID: 39881083
Thanks, Ron.  I had the linkfields set to soemthing.  When I removed them, it works fine.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

600 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