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 --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
