OrderBy Property

[mattpearcey]

I have a continuous subform within a frame form to display my records. However, at present they are ordering, i guess, by default to the ID number. I want them to order by Name of the record - Alpha. How do i do this? I have tried many different things in the OrderBy property in the form's properties, but it does not work.

Thank you for your help already.

Matt Pearcey

 

[LittleSmudge]

My first reaction was "You need to use the OrderBy property in the SUBform not the Main form in order to change the sort order in the SubForm"

But I guess you are doing it right but missed something in the description.

However,
When a new object is created, it inherits the RecordSource, Filter, OrderBy, OrderByOn, and FilterOn properties of the table or query it was created from.

So it is possible that your form has it's OrderByOn clause set to false. If this is the case then it will ignore anything you put in the OrderBy property.

Solution:-
In the OnLoad event of the SUBform place the code

Me.OrderByOn = True




'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[JeremyNYC]

Matt,

Is your subform based on a table or a query? If it's based on a table, make a query of that table and sort it to your heart's desire. Then base the subform on this.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.