"John S. Ford, MD" wrote in message
...

I did BOTH of those things (actually the property sheet shows my OrderBy
property is blank). I did put the line of code in my OnOpen event but
that didn't fix the problem.

"Dirk Goldgar" wrote in message
...

I expect that Albert's advice -- open the form in design view, clear the
Order By property, and save it -- will have solved your problem. If not,
you could add code to the form's Open event to set the OrderByOn property
to False:

Me.OrderByOn = False

... and that should also solve your problem.


That perplexes me, and I'll have to do some experimenting to see if I can
reproduce your problem. There's always the possibility that yuor form is
corrupted in some way, but I think that is much less llikely than that just
haven't yet hit on the cause of the behavior.

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

(please reply to the newsgroup)