Problem with dynamic filtering
Posted on 2009-07-13
I have a problem that doesn't make much sense and I'm hoping someone can help!
I have a data VIEW form with a subform. Master form is Complaints, child form is Products. When I put in a temporary filter (filter by selection button) on a field, it filters the records appropriately on the Master form. However, the child form locks in to the first record of the filter, and stays there as you page through the different records. When you unclick the Filter by Selection, the master form returns to full records, but the products subform still shows the one record.
I am looking for any suggestions of things to check into, or any help at all. This issue doesn't really make sense to me. I can't address this issue in VBA, I don't think, because the field that the Filter will be applied in will vary each time between about 30 different possible fields.
Any help or suggestions will be greatly appreciated!
Thanks in advance,