Linking a subform to another subform

[dcjones]

Hi All.

I have a from "frmMainClient" which has a subform "frmJob". They are linked using a field "accoint_no". when run the output show me the content of the "frmMainClient" and all the related jobs in the "frmJob" subform.

That fine. I now want to add another subform "frmSuppliers". I want to link the "frmSuppliers" to the "frmJob" using a field "supplierID" which is in both forms.

The end result required is the "frmMainClient" content is display along with all the records in the "frmJob" (linked) and all the records in the "frmSuppliers".

I hope I have been clear.

Can anyone point me inthe right direction to make this work.

Many thanks, keep safe and well.

Dereck

 

[le888]

You can put the frmSuppliers in the frmJob and linked to supplierID. This means that the frmSuppliers is the subform of frmJob.

Le

 

[dcjones]

Hi Le.

Yes thats what I want dto do but how do I code it. I have been playing around with this for hours.

Can you help, please.

 

[le888]

Is the same thing you did with the frmMainClient and frmJob. You open frmJob and insert frmSuppliers by using wizard insert form.


Le