M
Michael Smith via AccessMonster.com
I have a list of Project Summaries that is filtered before the user sees it
based on the user's LAN id and what organizations they have permission to
see.
I have a second list, multiselect, of values, FY02 through FY10.
I would like to filter the Project Summary list based on the selections
made in the FY list. I can do the code to create a WHERE statement using a
FOR EACH & NEXT procedure.
For the life of me, I cannot figure out how to then apply the FY parameters
to the displayed Project Summary list. I've tried WITH List and other ways
I've tried to modify based on rading other threads but to no avail.
Any assistance would be appreciated.
based on the user's LAN id and what organizations they have permission to
see.
I have a second list, multiselect, of values, FY02 through FY10.
I would like to filter the Project Summary list based on the selections
made in the FY list. I can do the code to create a WHERE statement using a
FOR EACH & NEXT procedure.
For the life of me, I cannot figure out how to then apply the FY parameters
to the displayed Project Summary list. I've tried WITH List and other ways
I've tried to modify based on rading other threads but to no avail.
Any assistance would be appreciated.