form shows duplicates

[human_anomaly]

I have a form that stores employee information such as name address ect. but it also stores a subform for each employee that has multiple listings for each employee. I have a feature that filters the data kinda like a search however when this data is diplayed in the form it shows multiple listings for each employee. For example say employee Sam has 5 listings in his sub form, well after I perform the filter there are 5 listings of Sam (name, address, ect.) and in each are his 5 sub form listings. I want just one listing of Sam with his 5 sub listings. Does anyone know whats going on here?

-Ben

 

[human_anomaly]

I think I did what your are explaning. Here is what I did the original query that had the problem had all the fields for the mainform and subform in it. When I split it up into two seprate queries one for the main form and one for the subform I get this problem: It all works out good however when I do a filter for one of the items in the subform it returns every employee and then the subform will either have data or not depending on whether it matches the filter. What I want to have happen is that when I enter a filter for the subform data it only returns those employees (mainform) for which the subform matches the filter.

 

[human_anomaly]

It works, but there is still a problem

I have got it to work the way I wanted it maybe even a little better than I was expecting, I had to add 3 new queries. I am having another problem now which I have already posted on the forum but have had no luck solving, you can view it here: http://www.access-programmers.co.uk/forums/showthread.php?p=276839#post276839