Filtering Sub Forms

[Sok Hong]

I just created a sub-table for a master table. The
subtable is linked by the ID field, and it's designed to
show the date and the status. However, when the form is
viewed by the user, I would like it to only show the last
date and status entered for that subform. Any Idea how I
can achieve this? Thank you.

 

[Marshall Barton]

I just created a sub-table for a master table. The
subtable is linked by the ID field, and it's designed to
show the date and the status. However, when the form is
viewed by the user, I would like it to only show the last
date and status entered for that subform. Any Idea how I
can achieve this?

I think you can get what you want by using a query for the
subform's record source:

SELECT TOP 1 IDfield, datefield, statusfield
FROM thesubtable
ORDER BY datefield DESC