Link subform bound to a crossroads query to form (1 Viewer)

K

kobiashi

Registered User.

Local time

Today, 22:30

Joined

May 11, 2018

Messages

258

• Sep 23, 2018

• #1

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

Sent from my ONEPLUS A6003 using Tapatalk

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 05:30

Joined

May 7, 2009

Messages

19,229

• Sep 23, 2018

• #2

if there is acommon field why not.

 

K

kobiashi

Registered User.

Local time

Today, 22:30

Joined

May 11, 2018

Messages

258

• Sep 23, 2018

• #3

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

Sent from my ONEPLUS A6003 using Tapatalk

 

MajP

You've got your good things, and you've got mine.

Local time

Today, 17:30

Joined

May 21, 2018

Messages

8,525

• Sep 23, 2018

• #4

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.