Filtering Sub Forms

  • Thread starter Thread starter Sok Hong
  • Start date Start date
S

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.
 
Sok said:
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?
Click to expand...


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
 
Back
Top