sql - 连接字段上的 SQL 字符串抛出错误

Question

以下 SQL 代码：

Private Sub EnableRowsource()
Dim sRowsource As String

Select Case lstReasons

Case 13                                                     
    sRowsource = "SELECT NRType, NRReason, (NRType & " - " & NRReason) As Concat FROM TBLnonroutine WHERE NRProcess='Bene' ORDER BY NRReason asc"
    
    cboNRReason1.RowSource = sRowsource
    cboNRReason2.RowSource = sRowsource
    cboNRReason3.RowSource = sRowsource
End Select

End Sub

在 Access 中给我一个类型不匹配错误。SQL 字符串位于 Access DB 表单的代码中。有人可以帮忙吗？

标签： sqlvbams-accesscombobox