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