如何基于组合框选择打开表单。

问题描述

我有一个名为switchboard的表格。并且它有两个组合框：组织和员工姓名缩写（cboOrganization，cboStaff_init）。还有一个名为OK的搜索按钮。参见图片DB1


我想要做的是，基于我的员工姓名缩写的选择。组合框，当我点击确定时按钮，我希望打开多个项目表单（测试2），仅对应于员工姓名缩写。参见图片DB2和DB 1.


我在这个VBA代码中真的很新，请尽可能提供代码。

I have this form called "switchboard" and in it are two combo boxes: Organization and Staff Initials (cboOrganization, cboStaff_init). There is also a search button called "OK". See picture "DB1"

What I want to do is, based on the selection of my "Staff Initials" combo box, when I click the "OK" button, I want the Multiple Items Form (Test 2) to open that correspond only to that "Staff Initials". See Picture DB2 and DB 1.

I''m really new at this VBA code, please provide code if possible.

推荐答案

展开 | 选择 | Wrap | 行号

这篇关于如何基于组合框选择打开表单。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！