2nd ORDER BY in form fields

Hello!

In Form, I have a Field1 with ORDER BY and work fine to
this field, but I would like to apply 2nd ORDER BY to 2nd
field too (Field2).
With ORDER BY in Field1, logically, isn't order the Field2.
Away the Table is ordered by Column1 Field1 and Column2
Field2.

Now, in Form, the order is:

Field1 Field2
1 C
1 A
1 B
2 B
2 A
2 C
3 B
3 A
3 C

I need:
1 A
1 B
1 C
2 A
2 B
2 C
3 A
3 B
3 C

I don't know to obtain this in Form. Therefore, any help
is welcome.
Thanks in advance.
an

On Thu, 24 Jun 2004 15:56:47 -0700, "an"
wrote:

With ORDER BY in Field1, logically, isn't order the Field2.
Away the Table is ordered by Column1 Field1 and Column2
Field2.

Well, actually it's not: it's an unordered "bag" of data.

Base the Form on a Query sorting by whichever fields you like, up to
ten of them (at least).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Ok.
Thanks for your reply and suggestion.
an


-----Original Message-----
On Thu, 24 Jun 2004 15:56:47 -0700, "an"
wrote:

With ORDER BY in Field1, logically, isn't order the
Field2.
Away the Table is ordered by Column1 Field1 and Column2
Field2.

Well, actually it's not: it's an unordered "bag" of data.

Base the Form on a Query sorting by whichever fields you
like, up to
ten of them (at least).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.