Continuous Forms and Subforms

I have a continuous form that list out the operations to machine a part.

I have a another continuous form that shows all the tools and materials need
to do that operation.

I want to add the materials form on the footer of the operations form but I
get an error that says this.

"A form with a subform cannot object can't have its default view property
set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one form. Both
forms need to be in continuous view because theirs no way of knowing how
many operation or list of materials each part needs.

Any suggestions?

Thanks,
Jasper

A couple of possibilities:

1. Use datasheet view instead of continuous forms. The subform can then
appear as a subdatasheet.

2. Use synchronised subforms, by which I mean this:

Create a main form, let's call it frmMain, with a default view of Form view.

Add your operations form (let's suppose it's called frmOperations) to
frmMain as a subform. Let us further suppose that the primary key for an
operation is a field called operation_id.

Add a text box to frmMain. Name it, say, txtOperation, and set it's Visible
property to False.

Program the Current event for frmOperations as follows:

Private Sub Form_Current()

Me.Parent!txtOperation = [operation_id]

End Sub

Underneath your frmOperations subform, add your materials form
(frmMaterials) as another subform of frmMain.

For the frmMaterials subform control:

Set the Link Child Fields property to operation_id
Set the Link Master Fields property to txtOperation

And test...

"Jasper Recto" wrote in message
...
I have a continuous form that list out the operations to machine a part.

I have a another continuous form that shows all the tools and materials
need to do that operation.

I want to add the materials form on the footer of the operations form but
I get an error that says this.

"A form with a subform cannot object can't have its default view property
set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one form.
Both forms need to be in continuous view because theirs no way of knowing
how many operation or list of materials each part needs.

Any suggestions?

Thanks,
Jasper

"Jasper Recto" wrote in
:

I have a continuous form that list out the operations to machine a
part.

I have a another continuous form that shows all the tools and
materials need to do that operation.

I want to add the materials form on the footer of the operations
form but I get an error that says this.

"A form with a subform cannot object can't have its default view
property set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one
form. Both forms need to be in continuous view because theirs no
way of knowing how many operation or list of materials each part
needs.

Any suggestions?

Thanks,
Jasper

Move up a level. Create the main (single) form at the part level.
Use the operations form (continuous) as a subform.

Create an (optionally hidden) unbound textbox on the mainform.
I'd call it txtOperationID or something like that.

In the subform, use the On Current event property to set
parent.txtOperationID to the current operation number.

Add your tooling subform to the _MAIN_ form, underneath the
operations subform. Set its link parent fields to the textbox
created above, and the link child to the step number in this
subform.

That's how I did it, anyways.


--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

Hi Jasper,

you CAN add a continuous form to the header or footer of another
continuous form ... Access will gripe, but just change the main form
view back to continuous

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Jasper Recto wrote:
I have a continuous form that list out the operations to machine a part.

I have a another continuous form that shows all the tools and materials need
to do that operation.

I want to add the materials form on the footer of the operations form but I
get an error that says this.

"A form with a subform cannot object can't have its default view property
set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one form. Both
forms need to be in continuous view because theirs no way of knowing how
many operation or list of materials each part needs.

Any suggestions?

Thanks,
Jasper

Omigosh, so you can! After all these years, still something new to learn!

Thanks Crystal, you've made my day!

"strive4peace" wrote in message
...
Hi Jasper,

you CAN add a continuous form to the header or footer of another
continuous form ... Access will gripe, but just change the main form view
back to continuous

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Jasper Recto wrote:
I have a continuous form that list out the operations to machine a part.

I have a another continuous form that shows all the tools and materials
need to do that operation.

I want to add the materials form on the footer of the operations form but
I get an error that says this.

"A form with a subform cannot object can't have its default view property
set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one form.
Both forms need to be in continuous view because theirs no way of knowing
how many operation or list of materials each part needs.

Any suggestions?

Thanks,
Jasper

you're welcome, bcap (what is your name?)

"Thanks Crystal, you've made my day!"

thank you, and now you made mine

~~~
you might also want to download, print, and read Access Basics in my
siggy ... it is only 100 pages and has lots of screen shots... there are
lots of links, which is why I suggest you download it in addition to
printing it out

each chapter is a separate file; right-click on each link and 'Save
Target As...'


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




bcap wrote:
Omigosh, so you can! After all these years, still something new to learn!

Thanks Crystal, you've made my day!

"strive4peace" wrote in message
...
Hi Jasper,

you CAN add a continuous form to the header or footer of another
continuous form ... Access will gripe, but just change the main form view
back to continuous

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Jasper Recto wrote:
I have a continuous form that list out the operations to machine a part.

I have a another continuous form that shows all the tools and materials
need to do that operation.

I want to add the materials form on the footer of the operations form but
I get an error that says this.

"A form with a subform cannot object can't have its default view property
set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one form.
Both forms need to be in continuous view because theirs no way of knowing
how many operation or list of materials each part needs.

Any suggestions?

Thanks,
Jasper

Real name's Brian. Thanks again!

"strive4peace" wrote in message
...
you're welcome, bcap (what is your name?)

"Thanks Crystal, you've made my day!"

thank you, and now you made mine

~~~
you might also want to download, print, and read Access Basics in my siggy
... it is only 100 pages and has lots of screen shots... there are lots of
links, which is why I suggest you download it in addition to printing it
out

each chapter is a separate file; right-click on each link and 'Save Target
As...'


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




bcap wrote:
Omigosh, so you can! After all these years, still something new to
learn!

Thanks Crystal, you've made my day!

"strive4peace" wrote in message
...
Hi Jasper,

you CAN add a continuous form to the header or footer of another
continuous form ... Access will gripe, but just change the main form
view back to continuous

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Jasper Recto wrote:
I have a continuous form that list out the operations to machine a
part.

I have a another continuous form that shows all the tools and materials
need to do that operation.

I want to add the materials form on the footer of the operations form
but I get an error that says this.

"A form with a subform cannot object can't have its default view
property set to continous forms."

Then it resets the form into a single form.


Is there a way around this? I want all this information on one form.
Both forms need to be in continuous view because theirs no way of
knowing how many operation or list of materials each part needs.

Any suggestions?

Thanks,
Jasper

Jasper,

Probably not telling you anything you now don't know :-) but you may
find this article of interest:
http://accesstips.datamanagementsolu...biz/subsub.htm

--
Steve Schapel, Microsoft Access MVP

strive4peace wrote:
Hi Jasper,

you CAN add a continuous form to the header or footer of another
continuous form ... Access will gripe, but just change the main form
view back to continuous