列表框字段排列的問題

loginwjd　发表于：2011-08-29 14:00:32 　

請問怎樣才能將"客戶代碼"和"訂單編號"位置調換.

列表框來源是這樣的:

Dim ftxt As String
    Dim cn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim stsql As String
    ftxt = Me.FIND_TEXT.value
    Set cn = Application.CurrentProject.Connection
    stsql = "SELECT PO as 訂單編號,customerid as 客戶代碼 FROM OrderTable WHERE PO like '" & ftxt & "' "
    rs.Open stsql, cn, adOpenKeyset, adLockPessimistic

    Set Me.lb.Recordset = rs

        rs.Close
        Set rs = Nothing
        Set cn = Nothing

謝謝!

Top

煮江品茶发表于：2011-08-29 17:12:17

dim ssql as string

ssql="SELECT PO as 訂單編號,customerid as 客戶代碼 FROM OrderTable WHERE PO like '" & Me.FIND_TEXT.value & "' "

Me.lb.RowSourceType = "Table/Query"
Me.lb.RowSource=ssql

Top

loginwjd 发表于：2011-08-29 17:23:18

煮江品茶谢谢你.

但为什么用记录集赋值就不行呢?

Top

总记录：2篇页次：1/1 9 1 :

Access交流中心

列表框字段排列的問題