Solved Errors while adding existing forms to navigation form (1 Viewer)

A1ex037

Registered User.
Local time
Today, 10:16
Joined
Feb 10, 2018
Messages
50
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

..forever waiting... waiting for jellybean!
Local time
Today, 17:16
Joined
May 7, 2009
Messages
19,169
you will need to change the Parameter of each Query to include the Navigation form:

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

A1ex037

Registered User.
Local time
Today, 10:16
Joined
Feb 10, 2018
Messages
50
Thanks, that did the trick. Had a criteria deep inside query that I have completely missed. Your suggestion did the trick.
 

Users who are viewing this thread

Top Bottom