Subforms, navigating to the last entry

[Sok Hong]

I added a subform to my current form. I want the sub form
to go the the last dated entry for that subform entry. If
possible I want it to show only the last dated entry, but
if that's not possible I would like to to at least
navigate to the last dated entry for the subform created.
Any clues?

 

[Shao]

I am assuming that you only want only the last dated
record showing up in the subform?

Make a query sorted descending. Make a subform in FORM
VIEW and make sure the navigation buttons in properties is
Yes. When the subform opens you will see the last record
should show up first.

If you don't want the ability to navigate just pick NO for
navigation buttons in the properties. The only record tht
will show will be your last record. Hope this helps.