Hi guys. I've been working on a database that has 2 related tables with a 1 to many relationship, I'm viewing the tables as a form with a sub form. My problem comes when I try to filter my main form, the filter displays the records I want from the main form but the related records are not displayed in the sub form.

I've had some sucess in getting around this problem by giving focus to the sub form before clicking Apply Filter but this doesn't always work.

I'm using Access 2002, does anyone know a solution to this problem or if it's just another Microsoft bug aka random feature.