Search on a Navigation Form (1 Viewer)

JASanjurjo

New member
Local time
Today, 02:11
Joined
Jul 24, 2019
Messages
5
i created a Navigation Form and attached a few forms to it but it keeps giving an error when i try to search on one of the forms but when i go to the individual form i'm able to search can someone help me
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:11
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to the forum. How exactly are you performing the search and what exactly was happening when you do it?
 

JASanjurjo

New member
Local time
Today, 02:11
Joined
Jul 24, 2019
Messages
5
i have a serach quary for specific information but when i added the the form to the navigation form it gives me an error
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:11
Joined
Oct 29, 2018
Messages
21,358
i have a serach quary for specific information but when i added the the form to the navigation form it gives me an error
Ah, if you had something like Forms!FormName.ControlName in your query, then you'll have to change it to something like this when you are using a Navigation Form:

Code:
Forms!NavigationFormName.NavigationSubformName.Form!ControlName
Hope it helps...
 

JASanjurjo

New member
Local time
Today, 02:11
Joined
Jul 24, 2019
Messages
5
here you can see what i got
 

Attachments

  • Help-1.jpg
    Help-1.jpg
    19.3 KB · Views: 41
  • Help-2.jpg
    Help-2.jpg
    69.3 KB · Views: 40

Pat Hartman

Super Moderator
Staff member
Local time
Today, 01:11
Joined
Feb 19, 2002
Messages
42,981
When you use the Access navigation form, only a SINGLE subform is ever loaded at one time. If you have a situation where you want to reference any subform other than the one currently visible, then you CANNOT use the Access navigation form. You must build your own custom navigation form. You can use the tab control to make the process a little easier.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:11
Joined
Oct 29, 2018
Messages
21,358
here you can see what i got
Hi. Sorry. When I downloaded your images and tried to view them, they were too small to see what was in them. Zooming in didn't help. Everything just got pixelated. Can you post a higher resolution image? Thanks.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:11
Joined
Oct 29, 2018
Messages
21,358
lets try again
Hi. I think that was better. So, where you have the following:
Code:
=[Numero]=Forms![SearchQ1]![Text83]
You may have to change it to something like:
Code:
=[Numero]=Forms![Navigation Form].[Navigation Subform].Form![Text83]
 

Users who are viewing this thread

Top Bottom