By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 759 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

Subform will only show 6 records

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.