Re: Display Records In Reverse Order

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 10/21/04


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
an issue.

-- 
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).