Solved

Sub form only shows first record

Posted on 2013-10-29
2
1,350 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

Back Up Your Microsoft Windows Server®

Back up 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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

777 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