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

Continuous forms with subforms

P: n/a
Hi NG

I need some help with a problem on my forms.

If I have 2 related tables, for instance companies and employees, and want
to display all companies on a continuous form with their employees on a sub
form as another continuous form, as shown below

Northwind

Carl Jensen

Dave Smith

Eastwind

Paul Allen

Susan Vincent

Brit Anderson

Southwind

Peter Simson

But as the number of employees varies on the companies, I would like the
subform to have the proper size to contain the number of employees on each
company.

So I got 2 problems, first, is there a way to simulate the property CanGrow
in form view? Maybe individually resizing the subform control on each
continuous form?

And secondly, resize each continuous form to fit the size of the subform.

Hope this makes sense, I will appreciate any input

And please bear with me for any incorrect language J

Best regards

Stef
Nov 6 '08 #1
Share this Question
Share on Google+
8 Replies


P: n/a
You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

"Steffen Beck" <sb@nospamsrd.dkwrote in message
news:49***********************@dtext01.news.tele.d k...
Hi NG

I need some help with a problem on my forms.

If I have 2 related tables, for instance companies and employees, and want
to display all companies on a continuous form with their employees on a
sub form as another continuous form, as shown below

Northwind

Carl Jensen

Dave Smith

Eastwind

Paul Allen

Susan Vincent

Brit Anderson

Southwind

Peter Simson

But as the number of employees varies on the companies, I would like the
subform to have the proper size to contain the number of employees on each
company.

So I got 2 problems, first, is there a way to simulate the property
CanGrow in form view? Maybe individually resizing the subform control on
each continuous form?

And secondly, resize each continuous form to fit the size of the subform.

Hope this makes sense, I will appreciate any input

And please bear with me for any incorrect language J

Best regards

Stef


Nov 7 '08 #2

P: n/a

"bcap" <bc**@nospam.nowhereskrev i en meddelelse
news:49***********************@news.zen.co.uk...
You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks
But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, almost just displayed as report

Best regards
Stef
Nov 7 '08 #3

P: n/a

"Steffen Beck" <sb@nospamsrd.dkwrote in message
news:49***********************@dtext01.news.tele.d k...
>
"bcap" <bc**@nospam.nowhereskrev i en meddelelse
news:49***********************@news.zen.co.uk...
>You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.


Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks
But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, almost just displayed as
report

Best regards
Stef

As I said, you could use a datasheet/sub-datasheet set-up. Or open a report
in preview...
Nov 7 '08 #4

P: n/a
On Nov 7, 5:43*am, "Steffen Beck" <s...@nospamsrd.dkwrote:
"bcap" <b...@nospam.nowhereskrev i en meddelelsenews:49***********************@news.zen. co.uk...
You can't have subforms on a continuous form, period.
If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks

But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, *almost just displayed as report

Best regards
Stef
For the past ten years or so I have rarely used subforms. Instead I
create and use my own "child" forms.

I open and place my own child form on my main form's opening, often
just to the right of my main form, which I place at (0,0).
I update my child form's recordsource and requery it in the OnCurrent
Event Code of my main form.
I close my child form on my main form's closing.

There are many reasons. One is the topic of this discussion.

I discuss this a bit more fully in
http://groups.google.com/group/comp....bc13deac192275

Nov 7 '08 #5

P: n/a

"Steffen Beck" <sb@nospamsrd.dkskrev i en meddelelse
news:49***********************@dtext01.news.tele.d k...
>
"bcap" <bc**@nospam.nowhereskrev i en meddelelse
news:49***********************@news.zen.co.uk...
>You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.
Thanks for your suggestions, I will take a closer look, but it seems like
there is no way I can get exactly what I want

Best regards

Stef
Nov 7 '08 #6

P: n/a

"Steffen Beck" <sb@nospamsrd.dkwrote in message
news:49***********************@dtext01.news.tele.d k...
>
"bcap" <bc**@nospam.nowhereskrev i en meddelelse
news:49***********************@news.zen.co.uk...
You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks
But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, almost just displayed as
report
>
Best regards
Stef

Place the fields in the main form on a subform then create a unbound main
form to hold both subforms. When you select new records on the primary
subfrom, update the recordsource on the 2nd subfrom. Depending on the
layout, you may need to place the subforms in different section of the main
form.
Nov 7 '08 #7

P: n/a
On Nov 7, 6:58*pm, "bcap" <b...@nospam.nowherewrote:
You can't have subforms on a continuous form, period.
You can have subforms in the footer of a continuous form.
Nov 8 '08 #8

P: n/a
Steffen Beck wrote:
Thanks for your suggestions, I will take a closer look, but it seems like
there is no way I can get exactly what I want
There is almost always a way to do something; you just have to weight
the cost/benefit.

You could create your own unbound form with as many controls as you like
but you'll have to handle the coding to make it all work.

--
'--------------------------
' John Mishefske
' UtterAccess Editor
' Microsoft MVP 2007, 2008
'--------------------------
Nov 9 '08 #9

This discussion thread is closed

Replies have been disabled for this discussion.