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.
I thank you greatly in advance for any assistance you can provide.