Hi ,
I have the Navigation form in which resides the Navigation subform inside which users put in the data. Now I want to create a search button in the main form to search a record by ID no which is a number.Users need to edit and update records, so hence will search by ID no. I have tried in the Main form the formula in macro builder for the command button by using Apply Filter function .
Syntax is
[ID No] Like "*" &[Forms]![NavigationForm]![NavigationSubform]![Textno] &"*"
It works fine in the Navigation subform but when opened from Navigation form it asks for parameters as Navigation subform is inside Navigation form
How can I fix this.
Many thanks.