Subform within Subform

[MasterBIB]

Hello there. Second time posting to this forum, hoping I can get a straight forward, easy to understand answer as I did the last time around (still a novice)!

I am attempting to add a subform within a subform that is referenced on a mainform. Currently, I have 3 tables.

Main Table
ExpID (PK)
ClientName
Vertical
Test Score

Table 2
VarID (PK)
ExpID (SK)
Variable

Table 3
ValID (PK)
VarID (SK)
Winner
Image

I have relationships setup between main table and table 2 based on ExpID and a relationship setup between table 2 and 3 based on VarID.

There can be multiple variables (varID) per experiment (expID) and multiple values(ValID) per variable (VarID).

I am attempting to create a form that has a subform within a subform.
Main Table
-> Table 2
-> Table 3

The idea being that within one form, I can add my experiment details and using a subform I can associate multiple variables to to that experiment, on top of that I should be able to add multiple values to each variable.

Any ideas how I may be able to do this? I tried setting up the subforms, however I am getting a prompt that says "enter parameter value Variable Table.Value Image". Im not sure why it is prompting me for a parameter.

Thanks in advance!

 

[edtab]

It appears that in the recordsource of your second subform, you are missing the field image.
Have a look at that first.

 

[MasterBIB]

Wow...should have known this!
Thanks for the reply