Sort Problem.

[Sadukar]

Hi all

I have 3 different sorts for a subform.
They work like this:
Me.Subform.Form.OrderBy = "[Type]"
Me.OrderByOn = True
etc....

My Problem is that when I open the form the sort will not work. If I right click on the subform and do a sort acending/desc etc.. the sort works. Then If i try my sorts via buttons my sorts work perfectly.

How can I get the sorts to work on opening the form?

Note: I have 5 identical forms. This problem is in 4 of the 5. The 5th works perfectly even though the code is the exact same.

Any Ideas?

S.

 

[LonnieJohnson]

Why not put the sorts in the recordsource of the subforms? Then it will automatically be there each time your load the forms.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!