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.
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.