Prev: where is the "on timer" function for forms in Access 2007?
Next: Date Picker Default?
From: Daryl S on 5 May 2010 12:08
Robeito -

Like John said, add the Country table to the query behind the form and use
that name in your form. You can hide this field if you want and still sort
on it, so the user interface is the same as what you have. Or, if the form
is not meant for updates, you could remove the combo box and just show the
country name.

--
Daryl S


"John W. Vinson" wrote:

> On Tue, 4 May 2010 13:04:01 -0700, robeito <robeito(a)discussions.microsoft.com>
> 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]
> .
>
 | 
Pages: 1
Prev: where is the "on timer" function for forms in Access 2007?
Next: Date Picker Default?