Drop-down list in a filter

[Shane]

I want to create a filter that asks the user for input. However, the input
will come from a drop-down box. That drop-down box will be populated from a
table in Project Server.

For example, I have a consolidated schedule that contains schedules from 10
different departments. I want to filter the consolidated schedule on a
particular department. The department is identified in an Enterprise Project
Outline Code field. When the user clicks on an icon, it opens a small form
that has the drop-down box, populated with the different departments taken
from the outline code field. The user selects a department and clicks on OK.
The selection is applied to a filter and the consolidated schedule reflects
the results of the filter.

Anyone have an idea on how to do this?
Thx

 

[Jan De Messemaeker]

Hi,

Been there several times.
Don't put the dropdown list in a filter.
Make a "general purpose" filter such as Flag5 equals yes.
Then link to the button you talk about a VBA procedure that
Opens a form
The form has combo box with a dropdown list
It is populated as you describe
The code calculates Flag7
The final statement of the procedure is filterapply

Hope this helps