Subform will only show 6 records

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • John Baker
    #1

    Subform will only show 6 records

    Hi:

    I have a sub form which i would like to show all the records selected from a table. There
    may well be over 100 of them. For reasons I cant fathom, the form will only show six, and
    then requires that you move using the record selection box to see any records below that.
    I would like the whole record set to be available using the vertical slider, since this is
    much more convenient for the user.

    Cab someone suggest what is wrong. The sub form is set to continuous form, so that's not
    the issue. Is there some setting that restricts the sub form to ONE page? If there is how
    do I override it?

    Regards

    John Baker
    Tags: None
    • Larry Linson
      #2
      Re: Subform will only show 6 records

      Do you have values in the LinkMasterField s and LinkChildFields properties of
      the Subform Control -- those are used to synchronize the records in the
      Subform's Form with the one record in the main Form.

      Other than that, I can only think that you have a problem in the sizing of
      the Form embedded in the Subform Control (it won't automatically expand to
      fill the Control) and won't shrink horizontally. The slider you need is
      likely the one on the Form embedded in the Subform control, not the one on
      the Subform Control itself.

      Larry Linson
      Microsoft Access MVP
      "John Baker" <Baker.JH@Veriz on.net> wrote in message
      news:hme420tf2i f2blqrev6belb7n 2v0r0j38b@4ax.c om...[color=blue]
      > Hi:
      >
      > I have a sub form which i would like to show all the records selected from[/color]
      a table. There[color=blue]
      > may well be over 100 of them. For reasons I cant fathom, the form will[/color]
      only show six, and[color=blue]
      > then requires that you move using the record selection box to see any[/color]
      records below that.[color=blue]
      > I would like the whole record set to be available using the vertical[/color]
      slider, since this is[color=blue]
      > much more convenient for the user.
      >
      > Cab someone suggest what is wrong. The sub form is set to continuous form,[/color]
      so that's not[color=blue]
      > the issue. Is there some setting that restricts the sub form to ONE page?[/color]
      If there is how[color=blue]
      > do I override it?
      >
      > Regards
      >
      > John Baker[/color]


        Comment

        • John Baker
          #3
          Re: Subform will only show 6 records

          Larry

          Thanks for your hints, and the time taken to write them. the problem was entirely my fault
          -- I was dealing with the wrong slider! Once I had edited the sub form down so that the
          slider could be seen in on the screen (it was outside normal screen view), it all came
          together!

          Thanks

          John Baker

          "Larry Linson" <bouncer@localh ost.not> wrote:
          [color=blue]
          >Do you have values in the LinkMasterField s and LinkChildFields properties of
          >the Subform Control -- those are used to synchronize the records in the
          >Subform's Form with the one record in the main Form.
          >
          >Other than that, I can only think that you have a problem in the sizing of
          >the Form embedded in the Subform Control (it won't automatically expand to
          >fill the Control) and won't shrink horizontally. The slider you need is
          >likely the one on the Form embedded in the Subform control, not the one on
          >the Subform Control itself.
          >
          > Larry Linson
          > Microsoft Access MVP
          >"John Baker" <Baker.JH@Veriz on.net> wrote in message
          >news:hme420tf2 if2blqrev6belb7 n2v0r0j38b@4ax. com...[color=green]
          >> Hi:
          >>
          >> I have a sub form which i would like to show all the records selected from[/color]
          >a table. There[color=green]
          >> may well be over 100 of them. For reasons I cant fathom, the form will[/color]
          >only show six, and[color=green]
          >> then requires that you move using the record selection box to see any[/color]
          >records below that.[color=green]
          >> I would like the whole record set to be available using the vertical[/color]
          >slider, since this is[color=green]
          >> much more convenient for the user.
          >>
          >> Cab someone suggest what is wrong. The sub form is set to continuous form,[/color]
          >so that's not[color=green]
          >> the issue. Is there some setting that restricts the sub form to ONE page?[/color]
          >If there is how[color=green]
          >> do I override it?
          >>
          >> Regards
          >>
          >> John Baker[/color]
          >[/color]

            Comment

            Previous template Next
            Working...