When I get a chance I would move the Properties Window so it doesn't obscure the Show Table dialog the next time;
Me.OrderBy = "CustomerName"
Me.OrderByOn = True
Mark L wrote:Here is another Access 2010 quirk; I won't exactly call it a bug, but it is different than prior versions.
In a nutshell, if you change the RecordSource of a report in the Open event, Access blows away any OrderBy clause.
Users browsing this forum: Bing [Bot], CCBot [Bot], Google [Bot] and 0 guests