I have a form made in MS Access97 with two sub forms containing linked parent chield fileds if I open the form and scroll through the records I can add, edit, delete, etc and all works exactly as supposed to. However If I apply a filter to the form from another form via a drop down list one of the sub forms fails miserably and will not calculate as it should. I require some one to tell me and show working example using my Access DB what I am doing wrong full zip code of db available.
1) error as described fixed and working properly in executable form as well as complete source code of all work done.
2)Complete ownership and distribution copyrights to all work purchased.