Access 2003 - Filtering a subform with a second sync'd subform
Posted on 2009-05-06
I recently created an unbound form with two subforms ( a master sub, and a detail sub). I added an unbound textbox to the main form and set it to equal a field in the master subform so it could be used to sync the detail form. That is working fine. What I want to do now is give the user the opportunity to filter the master sub based on some criteria. I initially used a combo box and linked it the same way I did the two sub forms(using Master and Child link properties of the master form), but then the Master form is ALWAYS limited to what is in the combo box. I would like it to be filtered when the user wants it to be filtered, and also be able to see the form totally unfiltered. I have no problem using VBA if that is necessary. What is the best way to accomplish this?