[AccessD] Recordset object transposes field order

Hi Susan

Sounds like the listbox's ColumnHeads are set to True.

/gustav


> 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