Need a Continuous Form With a Subform on it.

[dan.cawthorne]

Hi All,

Ive Noticed that access wont allow me to do the following, but i need
to find a work around, as a collegue would like to view the projects
details in a continuous form view, but i have a linked table which
allows me to assign multiply Clients to this table. which one project
might be recieved from one client, but another project might be off 3
Clients.

Now i can Achieve this by creating a report, but not in a form.

what can i do?

 

[Yanick]

--
Yanick

 

[Yanick]

It may just be the beginning of a solution but... did you tried to add both
form (The Continuous form & Subform) as subform on a new form?

I am not sure how you would link them cause I don't know about you design
but I am sure there is a way to do what you need.

 

[dan.cawthorne]

It may just be the beginning of a solution but... did you tried to add both
form (The Continuous form & Subform) as subform on a new form?

I am not sure how you would link them cause I don't know about you design
but I am sure there is a way to do what you need.

Well Oringanly Id Have single form set a Single type, with a subform
on it which what happens is when you change records on the main form
the related records appear / change on the sub form. Theres Only One
Field on the Subform which is Linked to the main form by the parent
and child links.

The Subform is set continuouse as i need to act as a list.

So i Created a Blank Form and Insersted the First Form (Which main
form) then i added the Subform and the subform dont seem to connect to
each other via the new form, the new form was on unbound form.


All I Want is to have a continuous form which allows me to show the
related records some how.

 

[Yanick]

Ok... you know what. I may not be able to help you on that. I did something
similar in the past but I did everything in VBA. You can create an hiden
field in the main from (which will contain your two forms), update that field
depending on your selection then update de ControlSource of the other 2 forms
to match what you need.

Would you need help with the Code?

 

[Albert D. Kallal]

You can't have a sub-form inside of a subform when continues.

however, the simple solution is to place two sub forms side by side.

I have an classic example of people and cheque amounts on the left side, and
on the right side that total check amount is distributed to *several* funds.

So, we have many records on the left side..and as we navage, the sub-form on
the right side shows the results for the navigation. You can see this
ms-access screen shot here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

(scroll down to the LAST screen shot).

So, you simply use two sub forms side by side..since they can't be inside of
each other..but, you get the same results anyway (that being a many to many
display).

 

[dan.cawthorne]

You can't have a sub-form inside of a subform when continues.

however, the simple solution is to place two sub forms side by side.

I have an classic example of people and cheque amounts on the left side, and
on the right side that total check amount is distributed to *several* funds.

So, we have many records on the left side..and as we navage, the sub-form on
the right side shows the results for the navigation. You can see this
ms-access screen shot here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

(scroll down to the LAST screen shot).

So, you simply use two sub forms side by side..since they can't be inside of
each other..but, you get the same results anyway (that being a many to many
display).

Thank you both, i think i see the logic,

So Albert D. Kalla

So What i can do is create a subform "frmProjects" which is records is
projects table, and have it a data sheet type then create a second
subform "frmClientsLink" Place these two Subforms on a new form and
place these subforms side by side,

So When any user clicks on any of the records on the frmProjects
subform the related records are shown on the second subform.

The Question is how do i link the 2 subforms as never done this.

 

[Albert D. Kallal]

The Question is how do i link the 2 subforms as never done this.

On the left side, our 1st sub form, in the on-current event, you have to
place some code to force a re-fresh of the right side (since the right side
is NOT a sub-form of the left side..it can't know to re-plot when you
move/navigate on the left side).

So, in the on-current event of the left form, you go:

Me.Parent.frmMyDetailsRightSide.Form.MyRequery

for the right side, simply use the link child/master setup

Something like:

link child fields: projectID
link child master: frmLeftSideForm.form!ID

 

[dan.cawthorne]

On the left side, our 1st sub form, in the on-current event, you have to
place some code to force a re-fresh of the right side (since the right side
is NOT a sub-form of the left side..it can't know to re-plot when you
move/navigate on the left side).

So, in the on-current event of the left form, you go:

Me.Parent.frmMyDetailsRightSide.Form.MyRequery

for the right side, simply use the link child/master setup

Something like:

link child fields: projectID
link child master: frmLeftSideForm.form!ID

Thank You Very Much