Wouldn't Order By address how the rows are sorted, not how the columns appear left-to-right?
Bryant --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > > You need to fill in the Order By line in the Properties for the listbox, > and/or add an "ORDER BY" clause in the query. The listbox "Order By" > will take precedence over the query order. > > Tobi > > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Databasedude.com > Sent: Thursday, December 08, 2005 9:48 AM > To: [email protected] > Subject: [AccessDevelopers] Field order reversed in listbox > > > I am creating an ADO recordset and assigning it as the source of a > listbox. However, the column order in the listbox is different from the > query. > > Here is the SQL statement: > > strSQL = "SELECT [TenantID], [TenantDisplayName] " _ > & "FROM qselTenantList_Temp " _ > & "WHERE TenantID = TenantID " > > That produces this result: > > TenantID TenantDisplayName > -------- ----------------- > ABC The ABC Corporation > 123 Lotus Company > > > In the listbox, TenantDisplayName appears, followed by TenantID. > > TenantDisplayname TenantID > ----------------- -------- > The ABC Corporation ABC > Lotus Company 123 > > Any ideas why it would switch column order? > > Thanks in advance, > Bryant > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
