I've read through plenty of postings on here regarding this message, but did not find one that suited my needs. I have "frmProfile" that has a tabbed control on it, "ProfileTab". On the first page, "Profile", Index(0), I have "cmbExemptStatus", a combo box that applies to an employee. What I need is when the user changes the selection in that combo box, it filters a combo box, "cmbBenefitsStatus" on another page, "Benefits", Index (2).
For example, if the user selects "Exempt" from the dropdown menu, it only displays options in cmbBenefitsStatus that apply to an exempt employee.
I have posted what I have for it as of now.
Private Sub cmbExemptStatus_Change()
If cmbExemptStatus = "Exempt" Then
cmbBenefitsStatus.RowSource "SELECT [benefits_dependant_status].[status_desc] FROM [benefits_dependant_status] WHERE [benefits_dependant_status].[status_desc] LIKE 'Salaried'"