Showing the most recent record in subform (1 Viewer)


New member
Jan 21, 2011
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.


Registered User
Sep 24, 2004
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom