There are some subtle new behaviors exhibited by Access 2007.  I will leave it to you to decide whether these are "bug" or "features." One is found when applying a filter to a form which has a child form embedded. 

Example: I have a form built around a list of classes (English, Math, Global Studies, those kind of classes).  For each class I have a subform showing the students in each class.  Sometimes I want to filter the list of classes, for example to show just the 9th grade classes. When I click on the Filter icon on the Access ribbon, and select the filter (all classes with "9th" in the title), the number of classes accurately reflects what I expect to see, but all of a sudden there are no students displayed! It appears that Access has applied the same filter to the subform, and no students meet the criterion.  If part of my goal is to delete classes which have no students, and I decide that this class has no students because I can't see any in the list, I can make a really annoying mistake at this point.

Solution: Make sure that the "Filtered" button on the subform, on the record navigation bar along with the navigation buttons for the subform, is not clicked.  It should read "Unfiltered", but if you apply a filter to the master form this sets the filtered property on the subform automatically.