Subform is blank in Form view

[wardw]

In the database described in my previous messages, in Form view of the main form, my subform is completely blank. In Form view of the subform itself, only the Form Header displays; the Detail area is blank. How can I change the settings so the subform displays?

Here's the Record Source of the subform:



SELECT Publications.PublicationName, PublicationColumns.PublicationColumnName
FROM AllDeathRecords INNER JOIN (Publications INNER JOIN (PublicationColumns INNER JOIN MultipleObituaries ON PublicationColumns.PublicationColumnID = MultipleObituaries.PublicationColumnID) ON Publications.PublicationID = MultipleObituaries.PublicationID) ON (Publications.PublicationID = AllDeathRecords.PublicationID) AND (PublicationColumns.PublicationColumnID = AllDeathRecords.PublicationColumnID) AND (AllDeathRecords.PersonID = MultipleObituaries.PersonID);

Here's a screen shot of the Record Source table relationships:

[Missinglinq]

This occurs when there are no Records in a Form's RecordSource and Records cannot be entered, i.e. the Form is Read-Only.

Allen Browne has an excellent article that explains why Multi-Table Queries are frequently Read-Only:

Why is my query read-only?

Linq ;0)>

[wardw]

Thanks for the link, Missinglinq. The form's RecordSource may not have records, because when the form opens the user hasn't entered any data yet. Not sure how to get around that problem.

I checked the Read-Only criteria Allen Browne listed, and the subform seems okay for all except one criterion: "It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables."

I'm not sure whether the query's FROM clause uses JOINs of different directions; they're all illustrated in the image I inserted in my previous posting. In any case, I don't know which tables I should remove from the query; they all seem necessary.