All Thanks for any help with this. If I can get this first part I can apply it to a lot of other functions I need to build.
In the attached DB there is a form [Recon_HoldErrorsEeco_Menu] with a subform [Recon_PositionErrors_SF].
There is a "Holdings Errors" menu on the left side with values.
The goal is: When the user clicks on of the numbers in the Menu, the subform filters to show only those values. There will be 3 filters and one unfilter function:
1) When Qty and Cash OOB "5" is clicked, the subform OOB column filters to show only the rows with the 5 non blank values
2) When Price vs Mkt Diff "6" is clicked, the subform Price vs. MVal column filters to show only the rows with the 6 non blank values
3) When Qty and Cash OOB "5" is clicked, the subform OOB column filters to show only the rows with the 4 non blank values
The filters do not build on each other. When one filter is selected there are no other activated.
4) The Unfilter Button will clear all filters
If this is a lot of code I apologize, and always appreciate an help.
FYI - In the Functions Custom group there are 2 "mdl..." filters generously provided by MajP. There is a lot of great logic in there for filtering by combo box values, but I am not good enough at this to translate that to what is needed above.
Once this is locked I should be able to apply the same logic to a lot of other similar filtering methods that will be added to this same form.
Thank again for the help.
In the attached DB there is a form [Recon_HoldErrorsEeco_Menu] with a subform [Recon_PositionErrors_SF].
There is a "Holdings Errors" menu on the left side with values.
The goal is: When the user clicks on of the numbers in the Menu, the subform filters to show only those values. There will be 3 filters and one unfilter function:
1) When Qty and Cash OOB "5" is clicked, the subform OOB column filters to show only the rows with the 5 non blank values
2) When Price vs Mkt Diff "6" is clicked, the subform Price vs. MVal column filters to show only the rows with the 6 non blank values
3) When Qty and Cash OOB "5" is clicked, the subform OOB column filters to show only the rows with the 4 non blank values
The filters do not build on each other. When one filter is selected there are no other activated.
4) The Unfilter Button will clear all filters
If this is a lot of code I apologize, and always appreciate an help.
FYI - In the Functions Custom group there are 2 "mdl..." filters generously provided by MajP. There is a lot of great logic in there for filtering by combo box values, but I am not good enough at this to translate that to what is needed above.
Once this is locked I should be able to apply the same logic to a lot of other similar filtering methods that will be added to this same form.
Thank again for the help.