Help with sorting/filtering

[sdballer]

Hello,

I was hoping someone could push me in the right direction on filtering some fields. I am using a MS template "Project Database"
Currently they have tabs Open Projects and Closed Projects. Both are using the Status field in combination with the Active (Yes/No) fields. The tabs form properties are using [Active]=False & [Active]=True, for those project tabs. My issue is that I am looking to add a new tab with "Current Projects" that would look the same as the others, but filter by [Status]... I was hoping it would be just as easy as [Status]=Current... but doesn't work. Can someone please help! =) thanks!

[June7]

Is this the web version? Do you really need web version? They are harder to modify and limited to macro coding.

Form modifications are done in Layout view.

That is a Navigation form which compounds the difficulties.

[sdballer]

Yes, its the web version and I do need it. For some reason when I do [Status]="20" as the value I need for "Current" it works for a moment, but then when I switch tabs, it defaults back to [Active]=False.

[June7]

That would be expected behavior.

From what little understanding I have of Navigation form/control, only one subform at a time is active. So each time you click a tab, current active subform is unloaded and another is loaded. The filter criteria is applied during load.

Might find this of interest https://www.accessforums.net/forms/t...orm-32053.html

Possibly you need to create a new tab for dynamic filtering on Status field. This tab would have a query or form as target object. The filtering would be by a dynamic parameter in query which is set by popup input or referencing a control on the main form for user input and macro code behind the control to requery the form. I am really grasping here because never built web db and don't use macros, only VBA.

[sdballer]

It's unusual because the filter gets deleted and replaced with another. Once i go back into the form properties, its reverted.

[June7]

I don't know what that statement means. My understanding of Navigation form and web db is very limited (put the two together and I am really lost). I can't even find how the form is filtered by True or False.

[sdballer]

I uploaded my database. The Current Projects tab is correct, except I don't want it to show Carry Forward. The Carry Forward tab is showing the same as Current, which should only be Carry. Canceled/Discontinued is working correctly.

Any help would be much appreciated. Thanks!