It is poss to create an expandable query in data sheet view that can be put on a form (some may know this as a drill down).