• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

Second Subform not showing all records

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?
0
BBlu
Asked:
BBlu
1 Solution
 
Rey Obrero (Capricorn1)Commented:
check the record source of the 2nd subform.
0
 
clarkscottCommented:
Make sure the second subform is not set to view only SINGLE RECORD.

Scott C
0
 
BBluAuthor Commented:
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.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
BBluAuthor Commented:
Hello Scott,
what option would the "Single Record" be under?  I don't see that.
0
 
IrogSintaCommented:
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.

Ron
0
 
BBluAuthor Commented:
Thanks, Ron.  I had the linkfields set to soemthing.  When I removed them, it works fine.
0
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

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now