There's no reason to create a query with joins to show form/subform data.
In most subform scenarios, the underlying tables are in a One to Many relationship, with the main/parent form on the One side and subforms records on the Many side.
Set each form/subform recordsource - independently - to the table that it pulls data from, then use the Link Master Fields and Link Child Fields properties in the Subform Control to create the link between the two (they're located under the Data properties
tab when the subform control is selected).
hth
Jack D. Leach (Access MVP)
Dymeng Services (home |
blog)
UtterAccess Wiki (hundreds of articles and functions)