mySQL = "Select [ZhongXInSN],[companyName] FROM [tblZhongXin] orDER BY ZhongXingID"
     Set Me.qCompany.Recordset = OpenADORecordset(mySQL)

上面代码设置组合框数据后，一般人都认为[ZhongXInSN]应该是在[companyName]前面，可是事实却不是这样：

mySQL = "Select [ZhongXInSN],[companyName] FROM [tblZhongXin] orDER BY ZhongXingID"
'改成
mySQL = "Select [ZhongXInSN] as 1,[companyName] as 2 FROM [tblZhongXin] orDER BY ZhongXingID"

顺序才对：

由此可见Recordset设置组合框字段出现的顺序并不是SQL写的顺序，而是按字段名的字符排序。