[AccessD] Recordset object transposes field order

Susan

Check the primary key index or filter on the table.

Glen


>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: RE: RE: [AccessD] Recordset object transposes field order
>Date: Thu, 8 Jul 2004 09:50:12 -0400
>
>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