Forum Discussion

EFCATECH's avatar
EFCATECH
Copper Contributor
Jun 06, 2022

ACCESS Form does not show all records when Subform is present

Hi All!

 

I'm suffering a strange quirk with my Access forms/subforms. Whenever I set up a form / subform combo the form does not show all the records it should be showing.

 

 

I have 3 tables. Table_1 holds the company data. When I select one ORGANIZATION (I have 7 right now) from the yellow dropdown ACCESS should populate the CONTACTS I have in said ORG and show them as a continuous subform (CONTACTOS). 

 

I get the list should nor be longer than whatever fits above the next subform (maybe 20+ at the moment?). But it's only showing 2 (out of a possible 33).

 

The lower subform shows all Interactions (call, visit, email, etc.) I had with that person (presently 1) that I selected in the CONTACTOS subform..

 

Notice there are 33 records in CONCTACTOS, but ACCESS is only showing 2. If I scroll down I can see all 33 just not at the same time.

 

If I remove the last subform or push the window up or down or pull the first form's background up or down the number of records shown grows or shrinks.

 

Any ideas as to why it happens and how I can fix it? I'm sure I'm missing some parameter somewhere in properties but I haven't found it yet.

 

Can I force ACCESS to show a certain number of records?

 

Please help!

Miguel

2016
access
Display
Form
subform
  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    MVP
    Jun 10, 2022

    Hi,

     

    For me it looks as if the footer section of the first subform, where the second one is in, is too high. I can't see it clearly because you turned off the dividing lines property of the subform. Set the dividing lines back to Yes or give the footer section a different background colour to check.

     

    If that's the culprite, then reduce the footer section to the height that is really needed for the second subform.

     

    Servus
    Karl
    Access News
    Access DevCon

     

Resources