Search a record in main form

[sunnyday]

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.

[June7]

Don't like and don't use navigation form/control. Review https://www.accessforums.net/forms/t...orm-32053.html