Records not sorting

B

Bob Richardson

What would prevent a continuous forms view from not sorting correctly. I've
tried setting up the ORDER BY property of the FORM, but I still see the data
in Primary Key order (an autonumber). I use a filter, which works correctly,
but I still get the data in numeric order, instead of by Lastname,
Firstname. Is there something that can block this sort order, or in some way
force the data to be in Key order?
 
T

tina

you can base the form on a query, rather than a table, and sort the records
in the query. or you can set the sort order in VBA, by adding the following
code to the form's Load event procedure, as

Me.OrderBy = "Lastname, Firstname"
Me.OrderByOn = True

hth
 
B

Bob Richardson

Thanks Van. I set the property to true in the Forms Onactivate event and all
worked. Then I commented that line out (' Forms.OrderByOn = true ) and it
still worked. Strange. Is there another way to access this property. I
didn't see it on the Property list. How would it have gotten set to false?
 
Top