Solved

Second Subform not showing all records

Posted on 2014-02-23
6
435 Views
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?
0
Comment
Question by:BBlu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 120

Expert Comment

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

Expert Comment

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

Scott C
0
 

Author Comment

by:BBlu
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.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

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

Accepted Solution

by:
IrogSinta earned 300 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.

Ron
0
 

Author Closing Comment

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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

730 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