Continuous Forms and Subforms

[Jasper Recto]

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

 

[bcap]

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...

 

[strive4peace]

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
*

 

[bcap]

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

Thanks Crystal, you've made my day!

 

[strive4peace]

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]

Real name's Brian. Thanks again!

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
*

 

[Steve Schapel]

Jasper,

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