"KC-Mass" connearney_AT_comcast_Period_net wrote in message
...
Hi John
Forms and reports ignore the order of your query.
Forms follow the order of the query, unless the OrderBy property is in
effect. By contrast, in reports the Sorting and Grouping specified in the
report design overrides the query/ However, if there is no sorting/grouping
in the report, and no OrderBy property in effect, then the query's ort order
is respected.
Open the form in design view and fill in the OrderBy field with
the NameOfQuery!Nameof Field.
Unfortunately you can only sort by one field but you could
build a composite field in your query depending on the fields of interest.
Actually, you can specify more than one field in the Order By property.
Just list the field names, separated by commas.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)