Filter Subform2 By data in Subform1

love2courtney

Hi there,
I need to add 2 subform into a main form. I then need to filter one of them with data stored in another subform (Something like subform link). Is there any chance to do that? I'm not able to do it.

Many thanks.

love2courtney

On nav 2009

Jan_Veenendaal

You can only do so by code, and you will probably need to use a timer to (e.g. every second) to get changes form subform1 and set (if something was changed) new filters on subform2.

Be aware that this (a) might easily create performance and locking issues, and (b) that forms using a timer are hard to debug.

In many cases there are other (better!) solutions to this issue, most preferable a different design without dependencies between subforms.

love2courtney

Jan_Veenendaal wrote: »

You can only do so by code, and you will probably need to use a timer to (e.g. every second) to get changes form subform1 and set (if something was changed) new filters on subform2.

Be aware that this (a) might easily create performance and locking issues, and (b) that forms using a timer are hard to debug.

In many cases there are other (better!) solutions to this issue, most preferable a different design without dependencies between subforms.

I got your point. Thank you.