OrderBy in Form

[Dkline]

I have a table which is displayed in a subform as a continuous form. It has
two fields which I want to control the order the records are displayed. I'm
trying to get them in ascending order but seemingly no matter how I set
OrderBy they are not in order.

In the table MEPricing they are ordered correctly.

Fields are MELEVEL and LEVELID on the Form MEPricing.

MELEVEL is the primary sort (and combination primary key) and LEVELID is
the secondary sort. I've set the OrderBy for the form as
MEPricing.MELevels,MEPricing.LevelID

What I want is and what I get when I look at the form by itself and not as a
subform:
MELEVEL LEVELID
ME9L1 1
ME9L2 2
ME9L3 3
ME9L4 4
ME9L5 5

Now when I look at it in the subform, what I get is:
MELEVEL LEVELID
ME9L3 3
ME9L4 4
ME9L5 5
ME9L1 1
ME9L2 2

All of the previous records - starting with ME1L1 through ME8L9 are fine -
perfect order. Just this ME9 group is out of whack when in the subform.

 

[Wayne Morgan]

In the Load event of the subform form try this code line

Me.OrderByOn = True

This should tell it to use the OrderBy entry you have made.