ApplyFilter in a form works fine, but not when moved to Navigation Form

[BigLou]

I am trying to get the following command (which works fine within the form “Need to send First Letter - Specified Range”) to work with the same Form moved into a Navigation Form. The record source for this Form is a query named “Need to Send First Letter”. It has 2 unbound text boxes called Minamt and Maxamt – where you can put a high and low number that you want to search between to narrow your results. Here’s the command:

DoCmd.ApplyFilter , "[TOTALTAX] Between [Forms]![Need to send First Letter - Specified Range]![Minamt] And [Forms]![Need to send First Letter - Specified Range]![Maxamt]"

When I run this within the Navigation Form (Named Navigation Form) I get a Run-time error ‘2491’ – The action or method is invalid because the form or report isn’t bound to a table or query.

I have searched high and low and tried multiple things, but cannot figure out what I need to do to make this work. Can anyone help?

[Micron]

Basically, the message means the form isn't bound to a table or updateable query, so you cannot apply a filter - there are no records bound to the form. However, you are showing the filter expression that was on your first form without mentioning if you changed the form reference to the navigation form, so the reference may be invalid.

[BigLou]

I have tried changing the reference - but that's my problem. I obviously don't know how to do it correctly, because nothing I have tried works. How do I change this?

[Micron]

I guess I'm not understanding and have no idea what the same Form moved into a Navigation Form means. I don't get how it can be the same form yet be moved to a form with a different name. If your expression worked before, and is looking at the same data but from a different form named "Navigation Form", then is the expression now not

DoCmd.ApplyFilter , "[TOTALTAX] Between [Forms]![Navigation Form]![Minamt] And [Forms]![Navigation Form]![Maxamt]" ?

[June7]

Don't like don't use navigation form. Review https://www.accessforums.net/forms/t...orm-32053.html

[BigLou]

I guess I'm not understanding and have no idea what the same Form moved into a Navigation Form means. I don't get how it can be the same form yet be moved to a form with a different name. If your expression worked before, and is looking at the same data but from a different form named "Navigation Form", then is the expression now not

DoCmd.ApplyFilter , "[TOTALTAX] Between [Forms]![Navigation Form]![Minamt] And [Forms]![Navigation Form]![Maxamt]" ?

No - that doesn't work. Navigation Forms are a way to create a nice looking tabbed interface in Excel. You just drag and drop your forms into it. Looks great - just doesn't work simply and apparently the syntax isn't logical. Lots of people have had similar issues with these.

[BigLou]

Don't like don't use navigation form. Review https://www.accessforums.net/forms/t...orm-32053.html

Thanks, but this didn't really help. I have tried several things found in Google searches, but none have worked for me. Guess Ill drop trying to use the Navigation Form.

[Micron]

No - that doesn't work. Navigation Forms are a way to create a nice looking tabbed interface in Excel. You just drag and drop your forms into it. Looks great - just doesn't work simply and apparently the syntax isn't logical. Lots of people have had similar issues with these.

Yeah, I Googled it after I posted. Sometimes my cart is in front of my horse Kinda sounds like a fancy tab control.
I'd like to update Access but can't justify it for recreational use. Sometimes I do work for my former employer, whose idea of updating MS Office in 2010 was to dump 2003 and buy 2007. Un-freakin believable for a company that generates $50 mil in sales every year!!