Link subform bound to a crossroads query to form

[kobiashi]

Is there anyway I can link a subform bound to a crosstab query to a form?

Sent from my ONEPLUS A6003 using Tapatalk

 

[arnelgp]

if there is acommon field why not.

 

[kobiashi]

It's all aggregated data, so there's no common field

Sent from my ONEPLUS A6003 using Tapatalk

 

[MajP]

To establish a link between a main form and a subform you really do not need related fields, you just need related data. You can even link subforms to unbound controls in the main form. The link is basically applying a filter. If you move to a record in the main form explain what records you want to see in the subform. Would help if you showed the sql for both the main and the subform crosstab.