strquery = "SELECT * FROM Customers,Orders WHERE Customers.客户号=" & Orders.客户号 & " And Customers.客户号 =" & dcbOrderNo.BoundText & "'"

这里有什么问题呀？运行老是出错

strquery = "SELECT * FROM Customers,Orders WHERE Customers.客户号='" & Orders.客户号 & "' And Customers.客户号 ='" & dcbOrderNo.BoundText & "'"
少了","

抱歉还是不行呀，

[此贴子已经被作者于2007-7-7 17:28:02编辑过]

strquery = "SELECT * FROM Customers,Orders WHERE Customers.客户号=Orders.客户号 And Customers.客户号 ='" & dcbOrderNo.BoundText & "'"

LS的代码应该是行的

   楼上的代码运行的时候没有报错，可是在datacombo下拉列表里面内容是空的