Multiple subform problems

[smeyer56]

I have a form that has 2 subforms on it. The main form is the company form. The first subform displays all contacts at that company and is linked by companyID. The second subform is linked to the first subform and shows details about the contact and is linked by contactID. Works great with one exception:
I need to keep old contacts but don't want them displayed on the first subform. I tried the filter property on the subform on the inactive checkbox with no luck, it does nothing. I tried creating a query that filters the information I need, but then the second subform quits working. After changing back to the original link and table, it still doesn't work until after I tweak, save, tweak, save etc.
I even changed the master/child links which are currently
ML:[Contact_Information Subform].Form![Contact_ID]
CL:Contact_ID

I have never run into something in Access that has been this complicated.

When I try to change the ML/CL for the second subform to query based subform it tells me that the "text you entered isn't on the list" and I think this is because the second subform isn't nested inside the first.

My main question is why doesn't the filter property work on the subform?
My second question is why I can't link to the query without lots of problems.

 

[smeyer56]

I have made this work using nested subforms(although it is not how the user wanted it to look). I was then able to use the query to filter the data and the nested subform updates accordingly. But now it is a little slow in getting the data(just the nested subform). I press on the "+" to display the subform and wait about a second or 2 before the data is displayed.

any way to speed this up?
Thanks
Steve

 

[Pampers]

Maybe put on index on the search field/variable?

Pampers
Keeping it simple can be complicated

 

[puforee]

Select properties on your first (contacts) sub form. Select Data - Record Sourse. Open the ... at the right side of the Record source. This opens the query that is presenting your contact data. For the field Inactive set the criteria to filter out the contacts that are inactive.

Your active only contacts should show and the second subform will show data only for the the records showing in the first subform.