Solved Errors while adding existing forms to navigation form

[A1ex037]

I've decided to move existing forms to a navigation form, and first step is giving me problems. If I add basic form, it goes OK. If I try to add form that has search in a listbox, it displays an error. Error displayed on frmSearchItems is:

Enter parameter value: Forms!frmSearchItems!txtKeywords.Text.

Many of our forms have smart /google-like search (plenty of names for it). I think that's because all those searches are form related, and now they are not called properly. For the particular error, the existing code is:

Private Sub txtKeywords_Change()
lstItems.Requery
End Sub

I've tried moving the code to a module, instead of a class, declaring it to public, but it doesn't work. Error remains the same. Am I on the right track or there is something else that needs to be done with it?

Thanks.

 

[arnelgp]

you will need to change the Parameter of each Query to include the Navigation form:

[Forms]![Navigation Form]![NavigationSubform].[Form]![txtKeywords]

 

[A1ex037]

Thanks, that did the trick. Had a criteria deep inside query that I have completely missed. Your suggestion did the trick.