Susan Harkins
ssharkins at bellsouth.net
Thu Jul 8 09:52:46 CDT 2004
The arrangement is correct and as expected. I haven't tested it with a combo or with other SELECT's yet -- I will when I have a bit of time. (Yeah... Right!) Susan H. Susan: What would happen if you plugged your select statement in as the row source of the list box instead of going through recordset? Rocky Original Message: ----------------- From: Susan Harkins ssharkins at bellsouth.net Date: Thu, 08 Jul 2004 09:50:12 -0400 To: accessd at databaseadvisors.com Subject: RE: RE: [AccessD] Recordset object transposes field order Right regarding Columm Heads, but that isn't the problem -- I think that discussion came about just through a misunderstanding of the problem. The list box is rearranging the columns. Specifically, it's transposing the first two columns. If I use a SELECT statement to populate the list box, the column order in the list box is correct. If I use a Recordset object via the Recordset property, the first two columns are flipflopped in the listbox. The Recordset itself is fine -- order is correct -- I checked it. The list box seems to do the flipping -- and Column Heads isn't involved. I just checked just to make sure and the order is wrong with Column Heads on or off. Susan H. When column heads are set to true it displays the field names, if set to false then only displays the records Paul -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com