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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
news:u%23TQ$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>