Current Location Flag

[mhankins]

In the picture below I have a list of locations in a sub form where a chart has been and the last record is it's current location. I'm generating a building report which should show a list of charts on that building, but it also shows it on old locations. So in the example, it shows for building 43 and building 83. I just need it to show on 83 and I have no idea how to accomplish this. Any ideas appreciated.

[June7]

Review: http://allenbrowne.com/subquery-01.html#TopN

If you only want to show one record in the subform, why use continuous view?

[mhankins]

A co-worker of mine solved the problem by using a filter on the report. Thanks for the suggestion.