Synchronize queries on form

[TomBP]

Hi,

I've made two queries. One in PivotChart and one in Datasheet view. Then I added both to a form.

When one query in the form is filtered the other should filter as well. Currently they are not "synchronized".

How can I make this happen?

Thanks in advance for your reply.


I've added a print screen with the visual overview as well as a Sample Database.

 

[namliam]

Instead of both using the table as the source, consider using the query as input for your crosstab, that way you ensure they always in synch

 

[TomBP]

Hi Mailman,

I'm afraid I don't understand. Could you please elaborate?

 

[namliam]

Instead of using the table as input for your Combo use the qry2

The use something called "filter by form" to write the filter into the SQL of qry2 in order to keep them synched. There is no way (I know off) that you can trap a filter being applied onto a subform in order to replicate said filter to a second form

For filter by form, see here:
http://www.access-programmers.co.uk/forums/showthread.php?p=1300908#post1300908
Among many other places I am sure.

 

[TomBP]

Looks like I have some reading to do. Thanks for pointing me in the right direction.