Linking sub-sub-form to overall master

[Vaughan]

My form has a sub form with a sub-sub-form.

The sub-sub-form needs to pick up [Project Number] from the sub-form: not a problem to link the two fields. It also has to pick up [Meeting Date] from the master form. I don't know how to link it to the master form.

Please can anyone help?

TIA

Vaughan

 

[Allen Browne]

Try setting the subform's LinkMasterFields property to:
[Project Number]; [Form].[Parent]![MeetingDate]

Alternatively, you could put a text box on the middle form, set its
ControlSource to:
=[Form].[Parent]![MeetingDate]
and nominate it as the second field in the LinkMasterFields

Recent versions of Access are pretty sensitive about some of these settings,
and are likely to crash, i.e. "Access has been shut down... Sorry for the
inconvenience." To work around this issue, make sure you actually have a
text box on each subform for the foreign key fields nominated in
LinkChildFields. Although Access is supposed to be able to handle referring
to the child fields directly, it can crash if the fields are not represented
by controls.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

My form has a sub form with a sub-sub-form.

The sub-sub-form needs to pick up [Project Number] from the sub-form: not

a problem to link the two fields. It also has to pick up [Meeting Date] from
the master form. I don't know how to link it to the master form.