Referencing a subform within a subform

[DataBug]

I cannot get this to work no matter what I do.

Form![MainForm].Form![Subform1].Form![Subform2]![Field]

The query containing this statement doesn't return anything and I get no prompts or error messages.

TIA

 

[alastair69]

i think it should be:-
Form![MainForm]![Subform1]![Subform2]![Field]
let me know if it works i can offer other work arounds if needed

 

[pbaldy]

http://www.mvps.org/access/forms/frm0031.htm