I have a SQL String that should query this table and select the Audit_Type "BAE" and place the results in the combo box drop down (cboQualRevCriteria) on the subform (frmQuality_Review_Subform
), but it is giving me everything in the table.
What is wrong with my SQL String and/or Code?
Select Case Me.cboAuditType.Text
myString = "select [Quality_Review_Criteria] from tblEnrollment_Dept_Criteria_Codes (for IMPORT) where [Audit_Type] = " & "BAE"";"
Me.frmQuality_Review_Subform.Form.cboQualRevCriteria.RowSource = myString
Me.frmQuality_Review_Subform.Form.cboQualRevCriteria.Enabled = True