Hi,

I Need help on MS Access forms.
I have a parent form and a child form linked using master and child fields.
Both forms are showing as datasheets during runtime.
When I click on (+) sign on master form, it is expanding with child rows as expected.


But, when I click on column header in child form for filtering, filter list is showing data irrespective of the given child records.
How to make filter list show data belongs to given child records only. (Or) if you can provide a way to capture the Event for (+) click, it will also help.

Thanks for your help in advance.