Showing the most recent record in subform (1 Viewer)

dbaldwin117

New member
Local time
Today, 02:49
Joined
Jan 21, 2011
Messages
6
In Access 2007, I have a form with a subform. The under lying tables are related one to many with referential integrity. When I display a specific record in the parent form, I would like the most recent related record to display in the sub form. The parent form's table has unique client info and the subform table has admission info, so the first record would refer to the first admission, which was subsequently closed, and the most recent record would involve the current admission. When the form is opend with the desired client displayed, the older closed admission info is displayed in the subform. What event and code can I use to automaticly display the most recent subform record?

I thank you greatly in advance for any assistance you can provide.
 

ted.martin

Registered User.
Local time
Today, 06:49
Joined
Sep 24, 2004
Messages
743
Sounds to me that all you need to do is have the RecordSource for the subform sorted in DESC order, so that the latest one shows first.
 

dbaldwin117

New member
Local time
Today, 02:49
Joined
Jan 21, 2011
Messages
6
Thank you. That did it.
 

Users who are viewing this thread

Top Bottom