How to apply filter button to each column like we do in exce

siamandm
BronzeLounger
Posts: 1224
Joined: 01 May 2016, 09:58

How to apply filter button to each column like we do in exce

Post by siamandm »

Hello All,

if i have a continuous form, and would like to add a filter arrow to each column like in excel how this possible?

Regards

User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to apply filter button to each column like we do in

Post by HansV »

I'd use a datasheet form for that. Re-creating the functionality of the filter arrow in a continuous form would be a lot of work.
Best wishes,
Hans

siamandm
BronzeLounger
Posts: 1224
Joined: 01 May 2016, 09:58

Re: How to apply filter button to each column like we do in

Post by siamandm »

does the search from text box work if i add this datasheet form has been ad as a subform?

User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to apply filter button to each column like we do in

Post by HansV »

Yes, that should still work.
Best wishes,
Hans

siamandm
BronzeLounger
Posts: 1224
Joined: 01 May 2016, 09:58

Re: How to apply filter button to each column like we do in

Post by siamandm »

thanks a lot yes it works,

Regards