Search Box Requerying Subform problem

[cbh35711]

Hello all,

I'm trying to build a text box to filter a subform. I have the main form "Navigation", the subform "Loan Search subform" and the textbox "Search"

When I run the Loan Search query with Search populated, it filters and works correctly. When i try to have it requery automatically, it doesn't seem to.


I have tried every combination of

Forms![Navigation]![Loan Search Subform].Requery 
Forms![Navigation]![Search].Requery
Forms![Navigation].[Search].Requery
Me![Loan Search subform].Form.Requery

that i can think of. Some throw error messages. Some seem to run throw the code, but no requery occurs.

I must be doing something fairly straight forward wrong, but googling isn't helping.



Thanks!

Chris

[cbh35711]

Certainly does help to have the correct version of the query on the form... Works fine now.