Filtering form inside a navigation form (1 Viewer)

yeng

New member
Local time
Today, 18:36
Joined
Nov 15, 2019
Messages
8
Hello, I'm looking for a solution on my problem. I have a form(DWIR) that have a combo box(SearchISO) that contains list of drawings from a table Isometric. Also have a subform(DWIR Subform) in Datasheet view which has a record source from a query(Iso Query) and has a criteria Forms!DWIR!SearchISO. This DWIR form works fine as intended to filter/display data selected in the combo box but when I put the DWIR form in a navigation form, it won't work anymore. I get an error "Forms!DWIR!SearchISO".


How can I get this to work using it in a navigation form?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:36
Joined
Oct 29, 2018
Messages
21,358
Hi. You'll have to change it to something like.

Forms!NavigationForm.NavigationSubform.Form!SearchISO
 

vba_php

Forum Troll
Local time
Today, 05:36
Joined
Oct 6, 2019
Messages
2,884
when I put the DWIR form in a navigation form, it won't work anymore. I get an error "Forms!DWIR!SearchISO".
what do you mean by "navigation form"? are you talking about "form view" (this is the default view for forms)? what view is your "DWIR form" in when you open it (for instance, continuous form, single form, split view)? from ur description, I assume single form view...
 

vba_php

Forum Troll
Local time
Today, 05:36
Joined
Oct 6, 2019
Messages
2,884
yeng,

I wasn't sure this was ur fault, so I tried to replicate the issue. In the attached DB, I did exactly what you're doing, however in my sample the combo doesn't work at all. No error, it just doesn't work. I'm using version 2010. hopefully my replication attempt is not missing anything. are you using the subform requery code that i'm using as well, or is your subform filtering automatically when the value in the combo is selected? It should.
 

Attachments

  • Database1.zip
    50.9 KB · Views: 73

yeng

New member
Local time
Today, 18:36
Joined
Nov 15, 2019
Messages
8
:p
Hi. You'll have to change it to something like.

Forms!NavigationForm.NavigationSubform.Form!SearchISO

I've tried this before with Forms!Main!DWIR.Form!SearchISO and tried today but didn't work.

I've dump this work around and went back to the previous file. I'm attaching the file with DWIR form working as intended but inside the Main form i'm getting pop-ups. I understand that navigation form queries itself and don't know how to work around with this issue.

Thanks.
 

Attachments

  • Test Weld.accdb
    592 KB · Views: 48

yeng

New member
Local time
Today, 18:36
Joined
Nov 15, 2019
Messages
8
yeng,

I wasn't sure this was ur fault, so I tried to replicate the issue. In the attached DB, I did exactly what you're doing, however in my sample the combo doesn't work at all. No error, it just doesn't work. I'm using version 2010. hopefully my replication attempt is not missing anything. are you using the subform requery code that i'm using as well, or is your subform filtering automatically when the value in the combo is selected? It should.

Hello!,

Thank you for the effort on trying to recreate the DB. Im attaching here the previous file where the DWIR form is working as intended in filtering the Isometrics but when it is inside the navigation form(Main) it won't work.

The first post is the work around I was trying to make and went here if there's any better code or idea to make it work.
 

Attachments

  • Test Weld.accdb
    592 KB · Views: 41

theDBguy

I’m here to help
Staff member
Local time
Today, 03:36
Joined
Oct 29, 2018
Messages
21,358
:p

I've tried this before with Forms!Main!DWIR.Form!SearchISO and tried today but didn't work.

I've dump this work around and went back to the previous file. I'm attaching the file with DWIR form working as intended but inside the Main form i'm getting pop-ups. I understand that navigation form queries itself and don't know how to work around with this issue.

Thanks.
Hi. See if this is what you wanted. Cheers!
 

Attachments

  • Test Weld.zip
    51.1 KB · Views: 53

yeng

New member
Local time
Today, 18:36
Joined
Nov 15, 2019
Messages
8
Hi. See if this is what you wanted. Cheers!

wow! that was fast. Yes, this is what I wanted. :)

I was really surprise with this "Forms!Main.NavigationSubform.Form!SearchISO" in the query code. Didn't see these code in most of the google searches/sites that i've visited 'til here. Glad I registered on this forum.

Thanks a lot sir.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:36
Joined
Oct 29, 2018
Messages
21,358
wow! that was fast. Yes, this is what I wanted. :)

I was really surprise with this "Forms!Main.NavigationSubform.Form!SearchISO" in the query code. Didn't see these code in most of the google searches/sites that i've visited 'til here. Glad I registered on this forum.

Thanks a lot sir.
Hi. You're very welcome. Glad we could assist. Good luck with your project.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 06:36
Joined
Feb 19, 2002
Messages
42,981
When you use the Access navigation form instead of building your own tabbed form, you must be aware that this specialized form type loads only ONE SINGLE subform at a time. One subform CANNOT refer to another subform because the subform is not loaded. If you need the subforms to "talk" to each other, you cannot use the Navigation form but you can build your own form with a tab control that looks and works very much like the Navigation form except that YOU have control of how the form operates rather than Access "helping" you out.
 

Users who are viewing this thread

Top Bottom