Subform not containing the data

[pmullan]

Hello Everyone. I have been working on a Form / Subform issue.
Scenario is as follows:
I have a main form called "frmShiftSummary". I am working on placing 3 sub forms into this main form so that the techs working their shift can obtain a summarized view of what transpired during the shift.

Background on the forms:
All the forms are currently "Unbound". Separately, each of the 3 sub forms work properly when viewed independently of the main form. Each of the 3 forms use a separate query which populates each form.

Issue:
When I place a subform into the main form, I attempt to use the following:
Source object = name of the sub form
Link Master fields = Date field on the main form (which is pulled from the Main DB Form.
Link Child Fields = Shift date field from the query used by the subform(subforms datasource)

When I test the form to view the data, the subform has no data. I am not sure what I am doing wrong.
I would appreciate help in this endeavor. Thank you, Patrick

 

[MarkK]

If you are using unbound forms then the mainform/subform links are not mediated by the LinkMasterFields and LinkChildFields properties of the subform control. Those properties assume you are using bound forms, and they will have no effect with unbound forms.

With unbound forms the onus is totally on the programmer to get the data in the form.

hth
Mark