policechiefwiggum
Programmer
Hi All,
I've started to get an issue with an IN statement.
Code below
This has been working fine, but now its started to stop filtering out projects that have a status of "closed".
I only have 4 possible status's (Active, Early Engaement, On Hold & Closed) so is there anyway i can code it to look for Closed projects and affectivly ignore them?
I've started to get an issue with an IN statement.
Code below
Code:
Dim ProjectRowSource As String
If Me.select_tester.Value > "" Then
Me.select_proj.Value = ""
Me.ViewProjectIndex.Value = ""
ProjectRowSource = "SELECT [ProjectTitle] FROM [projects] WHERE [UATTester] = '" & Me.select_tester.Value & "' AND [Status] IN ('Active','Early Engagement','On Hold')ORDER BY [projects].[ProjectTitle]"
Me.select_proj.Value = "Please Select a Project.."
Else
ProjectRowSource = ""
Me.select_proj.Value = "Please Select a Project.."
End If
Me.select_proj.RowSource = ProjectRowSource
This has been working fine, but now its started to stop filtering out projects that have a status of "closed".
I only have 4 possible status's (Active, Early Engaement, On Hold & Closed) so is there anyway i can code it to look for Closed projects and affectivly ignore them?