Subform will only show 6 records

[John Baker]

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

[Larry Linson]

Do you have values in the LinkMasterFields 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" <Ba******@Verizon.net> wrote in message
news:hm********************************@4ax.com...

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

[John Baker]

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" <bo*****@localhost.not> wrote:

Do you have values in the LinkMasterFields 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" <Ba******@Verizon.net> wrote in message
news:hm********************************@4ax.com.. .

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