[AccessD] Recordset object transposes field order

Susan Harkins ssharkins at bellsouth.net
Wed Jul 7 17:41:42 CDT 2004


I'm using a Recordset to populate a list box. When I open the form, the
CompanyName and CustomerID fields are transposed in the actual control --
anybody have any clue why? 
 
Susan H. 
 
 
Private Sub Form_Load()
  'Use Recordset as list box control
  'record source.
  Dim rst As ADODB.Recordset
  Dim lst As Access.ListBox
  Set rst = New ADODB.Recordset
  Set lst = lstPhone
  
  rst.Open "SELECT CustomerID, CompanyName, " & _
   "Phone, Fax FROM Customers", CurrentProject.Connection, _
   adOpenStatic, adLockPessimistic
  Set lst.Recordset = rst
End Sub



More information about the AccessD mailing list