How to set and removed filter in subform

G

Gabriel

I have a form with a sub form (datasheet form). In the main form I have a combo box where user can select a value then after update events will trigger a filter on the subform. It works fine, but now users want to have a button where they can remove the filter from the combo box (they want to see all the data in the subform).

I tried to play with the LinkChildFields and LinkMasterFields control but it didn't work properly.

Does anybody have experience with this kind of filtering problem ?

Thanks
Gabriel
 
Top