View Single Post
  #4  
Old May 4th, 2010, 09:47 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default datasheet: ¿how to order by the 2nd column of a combobox?

On Tue, 4 May 2010 13:04:01 -0700, robeito
wrote:

Thanks Daryl:

I must clarify my post:

Actually the data grid shows the information as I spected, but, when I use
the standar right click action of the mouse on the grid (sort A-Z, sort
Z-A, cut, copy paste, filter,...) and use the sort option, the grid is
sorted by the countries ID and that's not what I want, I want the grid sorted
by the alphanumeric name of the country


Then you will have to base the datasheet on a Query including the country
table.

The combo box is not data, is not part of your table, and is not something you
can sort: it's just a display tool, displaying data from *a different table*
(the combo's rowsource).
--

John W. Vinson [MVP]