Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sub form only shows first record

Posted on 2013-10-29
2
Medium Priority
?
1,515 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
[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
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 31

Accepted Solution

by:
hnasr earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
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…

618 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