A
Ayelet
If I'm not mistaken, in any printed report you can add up
to 10 sorting and grouping levels. this bit won't help you
on forms, but it can assist you when it comes to printing
your data.
As to forms, you can base your form on a query (rather
then directly based on the table), and in that query you
can also choose as many sorting parameters as you like,
and this should work.
To do this, press the "..." button near RecordSource on
the Form's Property Sheet, put the table.* in the fields
section, and then add Field3, Field2 and Field1 (in the
order you want them to sort by), uncheck the "Show", and
set the Sort to Ascending (or Descending, if you like).
Good Luck!
Ayelet
to 10 sorting and grouping levels. this bit won't help you
on forms, but it can assist you when it comes to printing
your data.
As to forms, you can base your form on a query (rather
then directly based on the table), and in that query you
can also choose as many sorting parameters as you like,
and this should work.
To do this, press the "..." button near RecordSource on
the Form's Property Sheet, put the table.* in the fields
section, and then add Field3, Field2 and Field1 (in the
order you want them to sort by), uncheck the "Show", and
set the Sort to Ascending (or Descending, if you like).
Good Luck!
Ayelet