auto form sort

[JIM.H.]

Hello,
My table is not sorted and I have an autoform on that, How
can I make auto form display data sorted?
Thanks,
Jim.

 

[Roxie Aho]

-----Original Message-----
Hello,
My table is not sorted and I have an autoform on that, How
can I make auto form display data sorted?
Thanks,
Jim.

There are other ways but I recommend basing the form on a
query and sort the query. If you sort on more than one
field, remember the left-most field on the query grid in
which you specify sort is sorted first, then the next
field to the right of it that you specify and so forth.

Roxie Aho
roxiea at usinternet.com

 

[GVaught]

Open the form properties and build a query against your record source. Click
the three ... and this will invoke the Query Builder. Make sure you place
all fields from your table into the query window. Sort accordingly by the
field you wish to sort by.