Populating Data from Main Form into Sub Form

[dannytuk_1982]

Hi

I'm relatively new to access and have recently been creating a 3-tier database form. The Top Level of the form is used to capture data of a mechanical fault on an industrial site. This links to a subform that shows all proposed solutions for the problem, their cost and whether they have been chosen to be implemented. Nestled into this is another subform that captures details of the work being done, etimated completion date etc.

There are 3 tables, and each subform displays the data from each table. They are called Work, ProposedSolutions and AcceptedSolutions.

I'm having a problem whereby I have a field WorkId in the 3rd subform, the 2nd subform takes this value from the main form without any problems. I'm assuming thats because its the primary key in the Work Table. How do I populate the same value again in the subform for AcceptedSolutions? At the moment you have to type in the WorkId manually which is far from ideal.

 

[RuralGuy]

What do you have set as the LinkChild/MasterFields for both the 1st SubForm and the 2nd SubForm?

 

[dannytuk_1982]

Hi Thanks for the reply,

The Link Child/Master Fields are set to Work Id and pass ok from the 1st to the 2nd form, however the data isn't being passed to the 3rd form.

 

[RuralGuy]

Is your 3rd SubForm inside of the 2nd SubForm or do you have the 2nd and 3rd SubForms side by side on a 4th SubFormControl?

 

[dannytuk_1982]

The 3rd form is placed within the 2nd subform.

 

[RuralGuy]

Normally a form/subform arrangement is used to display a 1:m relationship with the SubForm in Continuous Form mode. It sounds like all three of your forms are in Single Form mode. Is that correct?

 

[dannytuk_1982]

The 1st form is in a single form view that shows a certain problem with some machinery, it has a subform datasheet displaying any possible solutions, difficulty and cost of the solution etc. Inside this is another subsheet under a "+" symbol showing further information if the solution was accepted such as expected completion date of the work and estimated cost.

So it displays 1:many from 1st -> 2nd subform and then 1:1 for the 2nd -> 3rd subforms.

 

[RuralGuy]

It does not sound like you are using a SubForm Control to display the 3rd level form. Is that correct?

 

[dannytuk_1982]

Hi Thanks for your help,

I've changed the final subform to a 1:Many basis and its solved the problem for me.

 

[RuralGuy]

Great! Thanks for posting back with your success.