Re: Display Records In Reverse Order
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: Thu, 21 Oct 2004 19:50:37 +0800
Did you include the line:
Me.OrderByOn = True
The presence of the foreign key (ID1) and primary key (ID2) is normal - not
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Alan Henry" <AlanHenry@discussions.microsoft.com> wrote in message news:1F3EDA78-B32E-4622-AE63-13E82B39828D@microsoft.com... > Thanks for the quick response, > I have tried setting the OrderBy property of the subform to sort by the > date > in descending order, but it does not work. It will not sort any of the > fields > on the subform. The table for the subform contains two IDs ID1 is linked > to > ID1 of the main form. ID2 is the subform's own ID number. Could this have > anything to do with it? > > "Allen Browne" wrote: > >> Create a query that sorts the records as desired. >> Set the form's RecordSource to the name of the query. >> >> It is also possible to set the OrderBy of the form, using DESC to get >> descending order. Remember to set OrderByOn as well. >> >> >> "Alan Henry" <Alan Henry@discussions.microsoft.com> wrote in message >> news:1F482618-55FF-48DB-A7DE-84F48CDBAB01@microsoft.com... >> >I have a form which contains general information about gauges. This form >> > contains a subform listing the calibration history of the gauges. Is it >> > possible for records in the subform to be diplayed in reverse order, so >> > that >> > the last record entered is displayed first (reverse chronological >> > order).