Sorting with Forms

[dakota81]

I'm beginning to learn Access and have run into a point where I can't find the answer in the book. I have a form that comes up and in it there is a subform. Simply put, I want the records that appear in the subform sorted by date, I have a field in it called Date, and such I am trying to sort them. I can't quite figure out how to do this and so here I am. Any help would be greatly appreciated.

Also, if anyone knows, how can I set a subform to appear in either form view or datasheet view, whichever one I want, that's another point I'll have to look into.

 

[LonnieJohnson]

Go to the design view of your subform (not your main form) and open the properties window for the form. In the Data Tab go to the Order By line and type the name of your record source (table or query), a dot, then the field you wish to sort by:

MyTable.DateField

B-) ljprodev@yahoo.com
Professional Development
MS Access Applications