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: CCBot [Bot], Egg 'n' Bacon and 0 guests