Navigation form and "search Fields"

[gheyman]

I had a form with a search field on it (Query criteria) which worked great. Once I "moved" the form onto a Navigation form I have problems with it.



When you open the Nav Form you get a pop up form titled Enter Parameter value ? It is referencing the the Text box I am using on the original form (not the one in the Navigation Form.

Has anyone else had this problem and come up with a solution?

Thanks

[June7]

The form is now a subform and cannot be referenced the same way. Review https://www.accessforums.net/showthread.php?t=32053

On a normal form with subform container control, controls on the form that is now a subform must be referenced through the container control.

[gheyman]

The form is now a subform and cannot be referenced the same way. Review https://www.accessforums.net/showthread.php?t=32053

On a normal form with subform container control, controls on the form that is now a subform must be referenced through the container control.

Thanks. Is FnameTXt the Field name. Or is it the Feild name wth "txt" added to the end of it?

Like "*" & [Forms]![NavigationForm]![NavigationSubform]![FnameTxt] & "*"

[gheyman]

Thanks. Is FnameTXt the Field name. Or is it the Feild name wth "txt" added to the end of it?

Like "*" & [Forms]![NavigationForm]![NavigationSubform]![FnameTxt] & "*"

I ask because this is not working with the Textbox name, actually it doesn't work either way.

Like [forms]![frmBidItemsNav]![frmBidItemHistorySearch]![txtBidHistorySearch] & "*"

PS, should the Search field be a separate Text box on the Navigation form in the header section? I am using the unbound text box in the form that is also the subform in the Nav form.

Thanks

[June7]

NavigationForm still has subform container control and referencing subform fields/controls must be through the container. However, there is only one container and it is named NavigationSubform unless you changed the container's Name property. The object referenced by the container is dynamically loaded by clicking tabs (tab's NavigationTargetName property manages this). This is how NavigationForm differs from a normal form with subforms placed on pages of a Tab control.

FnameTxt is name of field or control.

Try:

LIKE [Forms]![frmBidItemsNav]![NavigationSubform]![txtBidHistorySearch] & "*"