Continuous Sub form

I need help with this...I have a subform that shows only one  record and new record.  I did a continuous form and it  shows it like that when I view the subform.  But when I view the main only shows the one record??  How do I show all the records that I queried??
Jass SainiAsked:
Who is Participating?
EirmanConnect With a Mentor Chief Operations ManagerCommented:
Just wondering JAss SAini, perhaps you want a split form.

With a split form you can see your data in datasheet format and form view simultaneously.
What field did you use for Linking the subform ?

You should check Under Data/Link Master Fields-Link Child Fields
Jass SainiAuthor Commented:
I used the FinalID for both the master and child.  How does that affect the continuous form?  Sorry still new at this
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Dale FyeConnect With a Mentor Commented:
If the main form and subform are linked via a master/child relationship, the subform will only display the records which relate to the record displayed on the main form, this could be 0, 1, or many records in most applications.  If you want do display all of the records in the continuous subform, you would have to remove the link between the main form and the subform.

I generally only do this when I'm using the main form as a "wrapper" for the subform, and I want to be able to add command buttons and search boxes on the main form.
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
It is still not clear what you have here...
So lets start form the top.
A typical Mainform/subform is a Main form that displays 1 record  at a time (1 Customer, for example)
...and a continuous subform that displays "Many" records (all the orders for the one customer in the main form.)

As an example, you open the main form (Customers) and move to customer 47.
At that point, all the Orders for Customer 47 will be displayed in the subform.

So when you say:
"How do I show all the records that I queried" is not clear what you are doing, (querying?) or expecting the results to be ("all the records?).

So can you explain exactly what you have, ...and what you are trying to accomplish?


Jeffrey CoachmanMIS LiasonCommented: other words explain it something like this:
"I have a main form that displays ____________"
...and the subform displays _____________.
I want to ____________ and then see all ____________

...or post a sample database with explicit instructions on how to see this issue.
Jass SainiAuthor Commented:
Sorry.. I just met with my boss's boss and he wants me to go a different route.  Starting a new question for that..
Jass SainiAuthor Commented:
Thank You..
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.

All Courses

From novice to tech pro — start learning today.