Solved

Sub form only shows first record

Posted on 2013-10-29
2
1,319 Views
Last Modified: 2013-10-29
I have a main form which contains a sub-form.  The link field is MasterID for both.

But the subform only shows the first record and I know there are two records.

Also, and I'm sure this is a clue...  when you make an entry in the subform normally another row opens up in view but that is not happening.

???
0
Comment
Question by:SteveL13
2 Comments
 

Author Comment

by:SteveL13
ID: 39610009
Also, the record selector at the bottom of the sub form shows 1 of 2.  But only one is displaying.
0
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 39610041
Check to see if the subform default view is not Single Form.
If single form is used you need to click the record selector to view other record.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

911 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

24 Experts available now in Live!

Get 1:1 Help Now