访问下拉菜单以过滤子表单

很抱歉，如果已经回答了这个问题，但是是我的新手，我看不到有什么对我有帮助，

Apologies if this has been answered but being new to access i cant see what will help me,

我有一个访问表单，其中有一个子表单，其中显示了工程师名称和一个复选框，可在为工程团队记录停机时间时选择.但是有4个团队，而且他们通常会越来越大，这意味着我们现在必须滚动浏览名称才能找到想要的工程师.

I have a access form that as a subform in it that displays an engineer name and a tickbox to select when logging downtime for the engineering team. however there is 4 teams and they are generally getting bigger which now means we have to scroll through the names to get to an engineer we want.

我在一张桌子上列出了所有工程师以及与他们相关的团队的列表，并且在主窗体上有一个下拉列表，列出了各个团队.当我从下拉列表中选择团队时，我希望子表单过滤掉不属于选定团队的所有工程师.

I have a list of all the engineers and what team they are associated to on 1 table and on the main form there is a dropdown with the teams on. When i select a team from the dropdown i want the subform to filter out any engineers that dont belong to select team.

其他信息

Subform_SelectEngineer

Subform_SelectEngineer

下拉名称为TeamFilter

Dropdown name is TeamFilter

希望这是重要的信息