subform requery after parent form filtering

[Wysy]

Hi,
I have a form with two subforms that are linked together. Everything works fine: scrolling through subform1 shows always the correct linked data in subform2. However when i apply filter on subform1 that requery does not work so subform2 stays empty. I have read about reassinging the subform control - SourceObject but not sure how to do it.
thanks

 

[isladogs]

Is this a split form?

 

[Wysy]

No. They are two linked subform.

 

[isladogs]

What code are you using to requery subform2?

 

[Wysy]

Me.Parent.Controls!Parentform.Requery

 

[isladogs]

That's incorrect. For correct syntax, see http://allenbrowne.com/casu-04.html

 

[Wysy]

I see. But why it does work without filtering and fails only if filters are applied?

 

[Wysy]

But why it does work without filtering and fails only if filters are applied?
Anyone?

 

[isladogs]

There are many possible reasons but you haven't given enough info for anyone to do other than make wild guesses.