SQL statement

[anb001]

I have the following SQL statement:

     strSQL = "SELECT DISTINCT tblDeadline.Direction FROM tblDeadline "
     strSQL = strSQL & " WHERE tblDeadline.Port = '" & cboPort.Text & "' AND tblDeadline.Service = '" & cboService.Text & "'"
     strSQL = strSQL & " ORDER BY tblDeadline.Direction;"

Problem is that I can't get the 'AND' part to work. What have I made wrong??

Thanks.

 

[Mile-O]

     strSQL = "SELECT DISTINCT Direction FROM tblDeadline "
     strSQL = strSQL & "WHERE Port = """ & cboPort & """ AND Service = """ & cboService & """"
     strSQL = strSQL & " ORDER BY Direction;"