Re: Need a Continuous Form With a Subform on it.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 28 Jan, 23:34, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@xxxxxxx>
wrote:
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).

--
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKal...@xxxxxxx

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

Quantcast