Hello All,
I am needing help with adding an additional criteria to the below VBA language.
Me.MSProductionSubform.Form.Filter = "[Status] = 'MLO Evaluation Completed' And [Assigned Analyst] = '" & Me.UserQueueSelected & "' And [Testing Month] = '" & Me.Testing_Month & "'"
Me.MSProductionSubform.Form.FilterOn = True
Where the status = MLO Evaluation completed, i would like to also add in 'Final QC Completed
So to conclude, i would like the status = 'MLO Evaluation Completed' And 'Final QC Completed, Final QC Incomplete.
I am needing help with adding an additional criteria to the below VBA language.
Me.MSProductionSubform.Form.Filter = "[Status] = 'MLO Evaluation Completed' And [Assigned Analyst] = '" & Me.UserQueueSelected & "' And [Testing Month] = '" & Me.Testing_Month & "'"
Me.MSProductionSubform.Form.FilterOn = True
Where the status = MLO Evaluation completed, i would like to also add in 'Final QC Completed
So to conclude, i would like the status = 'MLO Evaluation Completed' And 'Final QC Completed, Final QC Incomplete.