Continuous forms are limiting me (Help!!!!)

R

Robert

Hi,

The form structure I need is to have a main form with its
default view set to "Continuous forms" and one of the
control objects in this form would be a subform. Seems to
me a pretty powerful way of organizing and viewing data
on a form.

How ever when I try to plug in the subform I get the
following error message "A form with a subform object
can't have its default view property set to continuous
forms"

I guess this is probably too far fetch for Access.
However if anyone knows a way around this, please get
back to me. Also I have vesion 2002, I would like to know
if this is possible in version 2003.

Thanking every one in advance,
Robert.
 
J

John Vinson

The form structure I need is to have a main form with its
default view set to "Continuous forms" and one of the
control objects in this form would be a subform. Seems to
me a pretty powerful way of organizing and viewing data
on a form.

How ever when I try to plug in the subform I get the
following error message "A form with a subform object
can't have its default view property set to continuous
forms"

Right... the problem is that this would imply an infinite cascade,
with each subform being displayed multiple times, one for each row on
the continuous form, all with different recordsources!

What you can do is use an unbound main form, with two subforms: a
"master" and "child" subform. If you set the Master Link Field
property of the second subform to

[Forms]![mainformname]![firstsubform].Form![controlname]

it will synch the second subform to the currently selected record on
the first subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top