Thread: Form doesn't sort records per the underlying query
View Single Post
  #45  
Old April 9th, 2009, 05:47 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access
Dirk Goldgar
external usenet poster
  
Posts: 2,529
Default Form doesn't sort records per the underlying query
"Fred" wrote in message
...
I'm not in the same expertise league as these other guys but here's
something
to try that that only takes 30 seconds and is a good thing to do anyway.
Open the query in design view and in it's properties (not the SQL or grid)
make sure the "order by" property is empty.


I would certainly recommend doing this, even though I can't (so far)
reproduce any effect on the form of the query's Order By property. Still,
I'm using Access 2003, not 2000, so there could be a difference between my
system and Dr. Ford's.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)