subform question

[Meryl]

I have a donations subform within a form which shows the
donations history and allows you to add a new donation.
When the donations subform is opened, I would like it to
display the last records (most recent donations) and not
the first.

How do you do this?

Many thanks.

 

[Scott McDaniel]

Use a query to drive your subform and set the DonationDate field (I'm
assuming you have one) SortOrder to DESC. Set your subform's RecordSource to
be something like this;

SELECT Field1, Field2, YourDonationDateField, etc etc FROM YourTable ORDER
BY YourDonationDateField DESC

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "