Filtering data on a form based on a field on another form
Posted on 2013-06-13
So I have this form, frmMembersSwitchBoard, On this form there are three choices.
They are Department, Division and Duty Section.
When you click on Department a combo box appears with a list of departments you can choose from. Once you choose the department the execute button appears. When you click the execut button I would like it to open the form frmPersonnelRows and filter that form based on the department field chosen on the form frmMembersSwitchBoard